Excel charts: add title, customize chart axis, legend and data labels (2024)

After you have created a chart in Excel, what's the first thing you usually want to do with it? Make the graph look exactly the way you've pictured it in your mind!

In modern versions of Excel, customizing charts is easy and fun. Microsoft has really made a big effort to simplify the process and place the customization options within easy reach. And further on in this tutorial, you will learn some quick ways to add and modify all essential elements of Excel charts.

3 ways to customize charts in Excel

If you've had a chance to read our previous tutorial on how to create a graph in Excel, you already know that you can access the main chart features in three ways:

  1. Select the chart and go to the Chart Tools tabs (Design and Format) on the Excel ribbon.
  2. Right-click the chart element you would like to customize, and choose the corresponding item from the context menu.
  3. Use the chart customization buttons that appear in the top right corner of your Excel graph when you click on it.

Even more customization options can be found on the Format Chart pane that appears on the right of your worksheet as soon as you click More options… in the chart's context menu or on the Chart Tools tabs on the ribbon.

Tip. For immediate access to the relevant Format Chart pane options, double click the corresponding element in the chart.

Armed with this basic knowledge, let's see how you can modify different chart elements to make your Excel graph look exactly the way you'd like it to look.

How to add title to Excel chart

This section demonstrates how to insert the chart title in different Excel versions so that you know where the main chart features reside. And for the rest of the tutorial, we will focus on the most recent versions of Excel.

Add title to chart in Excel

In Excel 2013 - 365, a chart is already inserted with the default "Chart Title". To change the title text, simply select that box and type your title:
Excel charts: add title, customize chart axis, legend and data labels (1)

You can also link the chart title to some cell on the sheet, so that it gets updated automatically every time the liked cell is updated. The detailed steps are explained in Linking axis titles to a certain cell on the sheet.

If for some reason the title was not added automatically, then click anywhere within the graph for the Chart Tools tabs to appear. Switch to the Design tab, and click Add Chart Element > Chart Title > Above Chart I (or Centered Overlay).
Excel charts: add title, customize chart axis, legend and data labels (2)

Or, you can click the Chart Elements button in the upper-right corner of the graph, and put a tick in the Chart Title checkbox.
Excel charts: add title, customize chart axis, legend and data labels (3)

Additionally, you can click the arrow next to Chart Title and chose one of the following options:

  • Above Chart - the default option that displays the title at top of the chart area and changes the graph's size.
  • Centered Overlay - overlays the centered title on the chart without resizing the graph.

For more options, go to the Design tab > Add Chart Element > Chart Title > More Options.

Or, you can click the Chart Elements button and click Chart Title > More Options…

Clicking the More Options item (either on the ribbon or in the context menu) opens the Format Chart Title pane on the right side of your worksheet, where you can select the formatting options of your choosing.

Add title to chart in Excel 2010 and Excel 2007

To add a chart title in Excel 2010 and earlier versions, execute the following steps.

  1. Click anywhere within your Excel graph to activate the Chart Tools tabs on the ribbon.
  2. On the Layout tab, click Chart Title > Above Chart or Centered Overlay.

Excel charts: add title, customize chart axis, legend and data labels (4)

Link the chart title to some cell on the worksheet

For most Excel chart types, the newly created graph is inserted with the default Chart Title placeholder. To add your own chart title, you can either select the title box and type the text you want, or you can link the chart title to some cell on the worksheet, for example the table heading. In this case, the title of your Excel graph will be updated automatically every time you edit the linked cell.

To link a chart title to a cell, perform the following steps:

  1. Select the chart title.
  2. On your Excel sheet, type an equal sign (=) in the formula bar, click on the cell that contains the needed text, and press Enter.

In this example, we are linking the title of our Excel pie chart to the merged cell A1. You can also select two or more cells, e.g. a couple of column headings, and the content of all selected cells will appear in the chart title.
Excel charts: add title, customize chart axis, legend and data labels (5)

Move the title within the chart

If you want to move the title to a different place within the graph, select it and drag using the mouse:
Excel charts: add title, customize chart axis, legend and data labels (6)

Remove the chart title

If you don't want any title in your Excel graph, you can delete it in two ways:

  • On the Design tab, click Add Chart Element > Chart Title > None.
  • On the chart, right-click the chart title, and select Delete in the context menu.

Excel charts: add title, customize chart axis, legend and data labels (7)

Change font and formatting of chart title

To change the font of the chart title in Excel, right-click the title and choose Font in the context menu. The Font dialog window will pop up where you can choose different formatting options.
Excel charts: add title, customize chart axis, legend and data labels (8)

For more formatting options, select the title on your chart, go to the Format tab on the ribbon, and play with different features. For example, this is how you can change the title of your Excel graph using the ribbon:
Excel charts: add title, customize chart axis, legend and data labels (9)

In the same way, you can change the formatting of other chart elements such as axis titles, axis labels and chart legend.

For more information about chart title, please see How to add titles to Excel charts.

Customizing axes in Excel charts

For most chart types, the vertical axis (aka value or Y axis) and horizontal axis (aka category or X axis) are added automatically when you make a chart in Excel.

You can show or hide chart axes by clicking the Chart Elements button Excel charts: add title, customize chart axis, legend and data labels (10), then clicking the arrow next to Axes, and then checking the boxes for the axes you want to show and unchecking those you want to hide.

For some graph types, such as combo charts, a secondary axis can be displayed:
Excel charts: add title, customize chart axis, legend and data labels (11)

When creating 3-D charts in Excel, you can make the depth axis to appear:
Excel charts: add title, customize chart axis, legend and data labels (12)

You can also make different adjustments to the way that different axis elements are displayed in your Excel graph (the detailed steps follow below):
Excel charts: add title, customize chart axis, legend and data labels (13)

Add axis titles to a chart

When creating graphs in Excel, you can add titles to the horizontal and vertical axes to help your users understand what the chart data is about. To add the axis titles, do the following:

  1. Click anywhere within your Excel chart, then click the Chart Elements button and check the Axis Titles box. If you want to display the title only for one axis, either horizontal or vertical, click the arrow next to Axis Titles and clear one of the boxes:
    Excel charts: add title, customize chart axis, legend and data labels (14)
  2. Click the axis title box on the chart, and type the text.

To format the axis title, right-click it and select Format Axis Title from the context menu. The Format Axis Title pane will appear with lots of formatting options to choose from. You can also try different formatting options on the Format tab on the ribbon, as demonstrated in Formatting the chart title.

Link axis titles to a certain cell on the sheet

As is the case with chart titles, you can link an axis title to some cell on your worksheet to have it automatically updated every time you edit the corresponding cells on the sheet.

To link an axis title, select it, then type an equal sign (=) in the formula bar, click on the cell you want to link the title to, and press the Enter key.
Excel charts: add title, customize chart axis, legend and data labels (15)

Change the axis scale in the chart

Microsoft Excel automatically determines the minimum and maximum scale values as well as the scale interval for the vertical axis based on the data included in the chart. However, you can customize the vertical axis scale to better meet your needs.

1. Select the vertical axis in your chart, and click the Chart Elements button Excel charts: add title, customize chart axis, legend and data labels (16).

2. Click the arrow next to Axis, and then click More options… This will bring up the Format Axis pane.

3. On the Format Axis pane, under Axis Options, click the value axis that you want to change and do one of the following:

  • To set the starting point or ending point for the vertical axis, enter the corresponding numbers in the Minimum or Maximum
  • To change the scale interval, type your numbers in the Major unit box or Minor unit box.
  • To reverse the order of the values, put a tick in the Values in reverse order box.

Excel charts: add title, customize chart axis, legend and data labels (17)

Because a horizontal axis displays text labels rather than numeric intervals, it has fewer scaling options that you can change. However, you can alter the number of categories to display between tick marks, the order of categories, and the point where the two axes cross:
Excel charts: add title, customize chart axis, legend and data labels (18)

Change the format of axis values

If you want the numbers of the value axis labels to display as currency, percentage, time or in some other format, right-click the axis labels, and choose Format Axis in the context menu. On the Format Axis pane, click Number and choose one of the available format options:
Excel charts: add title, customize chart axis, legend and data labels (19)

Tip. To revert back to the original number formatting (the way the numbers are formatted in your worksheet), check the Linked to source box.

If you don't see the Number section in the Format Axis pane, make sure you've selected a value axis (usually the vertical axis) in your Excel chart.

Adding data labels to Excel charts

To make your Excel graph easier to understand, you can add data labels to display details about the data series. Depending on where you want to focus your users' attention, you can add labels to one data series, all the series, or individual data points.

  1. Click the data series you want to label. To add a label to one data point, click that data point after selecting the series.
    Excel charts: add title, customize chart axis, legend and data labels (20)
  2. Click the Chart Elements button, and select the Data Labels option.

For example, this is how we can add labels to one of the data series in our Excel chart:
Excel charts: add title, customize chart axis, legend and data labels (21)

For specific chart types, such as pie chart, you can also choose the labels location. For this, click the arrow next to Data Labels, and choose the option you want. To show data labels inside text bubbles, click Data Callout.
Excel charts: add title, customize chart axis, legend and data labels (22)

How to change data displayed on labels

To change what is displayed on the data labels in your chart, click the Chart Elements button > Data Labels > More options… This will bring up the Format Data Labels pane on the right of your worksheet. Switch to the Label Options tab, and select the option(s) you want under Label Contains:
Excel charts: add title, customize chart axis, legend and data labels (23)

If you want to add your own text for some data point, click the label for that data point and then click it again so that only this label is selected. Select the label box with the existing text and type the replacement text:
Excel charts: add title, customize chart axis, legend and data labels (24)

If you decide that too many data labels clutter your Excel graph, you can remove any or all of them by right-clicking the label(s) and selecting Delete from the context menu.

Data label tips:

  • To change the position of a given data label, click it and drag to where you want using the mouse.
  • To change the labels' font and background color, select them, go to the Format tab on the ribbon, and choose the formatting options you want.

Moving, formatting or hiding the chart legend

When you create a chart in Excel, the default legend appears at the bottom of the chart, and to the right of the chart in Excel 2010 and earlier versions.

To hide the legend, click the Chart Elements button Excel charts: add title, customize chart axis, legend and data labels (25) in the upper-right corner of the chart and uncheck the Legend box.

To move the chart legend to another position, select the chart, navigate to the Design tab, click Add Chart Element > Legend and choose where to move the legend. To remove the legend, select None.
Excel charts: add title, customize chart axis, legend and data labels (26)

Another way to move the legend is to double-click on it in the chart, and then choose the desired legend position on the Format Legend pane under Legend Options.
Excel charts: add title, customize chart axis, legend and data labels (27)

To change the legend's formatting, you have plenty of different options on the Fill & Line and Effects tabs on the Format Legend pane.

Showing or hiding the gridlines on the Excel chart

In Excel 2013, 2016 and 2019, turning the gridlines on or off is a matter of seconds. Simply click the Chart Elements button and either check or uncheck the Gridlines box.
Excel charts: add title, customize chart axis, legend and data labels (28)

Microsoft Excel determines the most appropriate gridlines type for your chart type automatically. For example, on a bar chart, major vertical gridlines will be added, whereas selecting the Gridlines option on a column chart will add major horizontal gridlines.

To change the gridlines type, click the arrow next to Gridlines, and then choose the desired gridlines type from the list, or click More Options… to open the pane with advanced Major Gridlines options.
Excel charts: add title, customize chart axis, legend and data labels (29)

Hiding and editing data series in Excel graphs

When a lot of data is plotted in your chart, you may want to temporary hide some data series so that you could focus only on the most relevant ones.

To do this, click the Chart Filters button Excel charts: add title, customize chart axis, legend and data labels (30) on the right of the graph, uncheck the data series and/or categories you want to hide, and click Apply.

To edit a data series, click the Edit Series button to the right of the data series. The Edit Series button appears as soon as you hover the mouse on a certain data series. This will also highlight the corresponding series on the chart, so that you could clearly see exactly what element you will be editing.
Excel charts: add title, customize chart axis, legend and data labels (31)

Changing chart type and style

If you decide that the newly created graph is not well-suited for your data, you can easily change it to some other chart type. Simply select the existing chart, switch to the Insert tab and choose another chart type in the Charts group.

Alternatively, you can right-click anywhere within the graph and select Change Chart Type… from the context menu.
Excel charts: add title, customize chart axis, legend and data labels (32)

To quickly change the style of the existing graph in Excel, click the Chart Styles button Excel charts: add title, customize chart axis, legend and data labels (33) on the right of the chart and scroll down to see the other style offerings.
Excel charts: add title, customize chart axis, legend and data labels (34)

Or, choose a different style in the Charts Styles group on the Design tab:
Excel charts: add title, customize chart axis, legend and data labels (35)

Changing chart colors

To change the color theme of your Excel graph, click the Chart Styles button, switch to the Color tab and select one of the available color themes. Your choice will be immediately reflected in the chart, so you can decide whether it will look well in new colors.
Excel charts: add title, customize chart axis, legend and data labels (36)

To choose the color for each data series individually, select the data series on the chart, go to the Format tab > Shape Styles group, and click the Shape Fill button:
Excel charts: add title, customize chart axis, legend and data labels (37)

How to swap X and Y axes in the chart

When you make a chart in Excel, the orientation of the data series is determined automatically based on the number of rows and columns included in the graph. In other words, Microsoft Excel plots the selected rows and columns as it considers the best.

If you are not happy with the way your worksheet rows and columns are plotted by default, you can easily swap the vertical and horizontal axes. To do this, select the chart, go to the Design tab and click the Switch Row/Column button.
Excel charts: add title, customize chart axis, legend and data labels (38)

How to flip an Excel chart from left to right

Have you ever made a graph in Excel only to find out that data points appear backwards from what you expected? To rectify this, reverse the plotting order of categories in a chart as shown below.

Right click on the horizontal axis in your chart and select Format Axis… in the context menu.
Excel charts: add title, customize chart axis, legend and data labels (39)

If you prefer working with the ribbon, go to the Design tab and click Add Chart Element > Axes > More Axis Options…
Excel charts: add title, customize chart axis, legend and data labels (40)

Either way, the Format Axis pane will show up, you navigate to the Axis Options tab and select the Categories in reverse order option.
Excel charts: add title, customize chart axis, legend and data labels (41)

Apart from flipping your Excel chart from left to right, you can also change the order of categories, values, or series in your graph, reverse the plotting order of values, rotate a pie chart to any angle, and more. The following tutorial provides the detailed steps on how to do all this: How to rotate charts in Excel.

This is how you customize charts in Excel. Of course, this article has only scratched the surface of Excel chart customization and formatting, and there is much more to it. In the next tutorial, we are going to make a chart based on data from several worksheets. And in the meanwhile, I encourage you to review the links at the end of this article to learn more.

You may also be interested in

  • How to create a pie chart in Excel
  • How to create a bar graph in Excel
  • How to add titles to Excel charts
  • How to create waterfall chart in Excel (bridge chart)
  • How to make a Gantt chart in Excel

I am a seasoned expert in Microsoft Excel, specializing in chart creation and customization. My proficiency is rooted in hands-on experience, having navigated the intricacies of Excel's charting capabilities extensively. I have successfully tackled diverse scenarios, from basic chart setups to intricate customization tasks, making me well-versed in optimizing visual representation in Excel.

In the provided article, the focus is on harnessing Excel's charting features to create visually appealing and informative graphs. Let's break down the key concepts covered:

1. Adding the Chart Title:

  • In Excel 2013-365, the default "Chart Title" is present, and you can modify it by selecting the title box.
  • Access the Chart Tools tabs, go to the Design tab, and click on "Add Chart Element" to customize the title's position and appearance.
  • The Format Chart Title pane provides additional formatting options.

2. Customizing Chart Axes:

  • Excel automatically adds vertical (Y axis) and horizontal (X axis) axes.
  • You can show or hide axes using the Chart Elements button and customize their titles.
  • Linking axis titles to cells enables automatic updates.
  • Adjust the axis scale, format axis values, and change the display of axis elements.

3. Adding Data Labels:

  • Data labels provide details about data series and can be added selectively.
  • Customize data labels' content, position, and formatting using the Chart Elements button and Format Data Labels pane.

4. Legend Management:

  • The legend is placed by default but can be hidden or moved.
  • Use the Chart Elements button or Format Legend pane to adjust legend position and formatting.

5. Gridlines:

  • Easily show or hide gridlines using the Chart Elements button.
  • Excel determines gridlines type automatically based on the chart type.

6. Editing Data Series:

  • Temporarily hide or filter data series using the Chart Filters button.
  • Edit data series for better focus on relevant information.

7. Changing Chart Type and Style:

  • Easily switch between chart types using the Insert tab or right-clicking on the chart.
  • Modify the chart style and color theme for a personalized look.

8. Swapping X and Y Axes:

  • Change the orientation of data series by switching rows and columns.
  • Use the Switch Row/Column button on the Design tab.

9. Flipping Excel Charts:

  • Reverse the plotting order of categories or values.
  • Utilize the Format Axis pane to achieve a left-to-right flip.

This comprehensive overview highlights the versatility of Excel's chart customization options, from basic elements to advanced formatting. As an enthusiast in this field, I encourage further exploration and experimentation with these features to enhance your Excel charting skills.

Excel charts: add title, customize chart axis, legend and data labels (2024)

FAQs

How do I add data labels and titles to a chart in Excel? ›

Add data labels

Click the chart, and then click the Chart Design tab. Click Add Chart Element and select Data Labels, and then select a location for the data label option. Note: The options will differ depending on your chart type. If you want to show your data label inside a text bubble shape, click Data Callout.

How do I customize axis labels in Excel? ›

Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4.

How do I add a title to a chart legend in Excel? ›

Select your chart and on the Chart Design tab, choose Select Data. Choose on the legend name you want to change in the Select Data Source dialog box, and select Edit. Note: You can update Legend Entries and Axis Label names from this view, and multiple Edit options might be available.

How do I add data labels to a chart in sheets? ›

Add data labels
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize. Series.
  4. Check the box next to “Data labels.”

How do I change chart labels in Excel? ›

In the worksheet, click the cell that contains the title or data label text that you want to change. Edit the existing contents, or type the new text or value, and then press ENTER. The changes you made automatically appear on the chart.

How do you write a title for a chart? ›

Chart titles best practices
  1. Chart titles and captions make visualizations far easier to comprehend. Use titles whenever possible. ...
  2. Use appropriate font and style. NEED CONTENT.
  3. Summarize the chart in plain english. ...
  4. Include the metric units. ...
  5. Include the time period. ...
  6. Use Dynamic Titles.

How do you customize a graph in Excel? ›

To add elements to your chart, such as a title and data labels, select the chart. The Chart Elements, Chart Styles, and Chart Filter buttons appear next to the chart. Click the Chart Elements button and check or uncheck the elements you want to add or remove, such as Chart Title.

How do I change the axis labels in sheets? ›

Change axis titles & tick marks
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Chart & axis title.
  5. Next to "Type," choose which title you want to change.
  6. Under "Title text," enter a title.
  7. Make changes to the title and font.

Where is the chart legend in Excel? ›

Show a chart legend
  1. Select a chart and then select the plus sign to the top right.
  2. Point to Legend and select the arrow next to it.
  3. Choose where you want the legend to appear in your chart.

What is a chart legend in Excel? ›

A legend in Excel matches data within a table or chart with what it represents, which can help prevent confusion when readers analyze a chart or graph. You can use a legend to show the same data differently, or it can clarify what the various axes, colors or labels on a chart mean.

What is a legend on a graph? ›

Legend. The legend identifies the visual elements used to distinguish different groups of data on the graph. The legend helps you evaluate the effects of grouping. For example, the legend in the preceding graph shows the attributes of the symbols and connect lines used to represent the Control and Education groups.

How do I show the axis title in an Excel chart? ›

Click the plus button in the upper right corner of the chart. 3. Click Axis Titles to put a checkmark in the axis title checkbox. This will display axis titles.

How do I add two data labels to an Excel chart? ›

On the Layout tab, in the Labels group, click Data Labels, and then click the option that you want. For additional data label options, click More Data Label Options, click Label Options if it's not selected, and then select the options that you want.

How do I add a secondary axis title to an Excel chart? ›

Add Secondary Axis Titles
  1. Select the dual axis chart.
  2. Click the Chart Elements button.
  3. Select the Axis Titles check box.
  4. Type a name in each axis text box.

How do I add an axis title sheet? ›

Change axis titles & tick marks
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Chart & axis title.
  5. Next to "Type," choose which title you want to change.
  6. Under "Title text," enter a title.
  7. Make changes to the title and font.

Top Articles
Latest Posts
Article information

Author: Rueben Jacobs

Last Updated:

Views: 6664

Rating: 4.7 / 5 (77 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Rueben Jacobs

Birthday: 1999-03-14

Address: 951 Caterina Walk, Schambergerside, CA 67667-0896

Phone: +6881806848632

Job: Internal Education Planner

Hobby: Candle making, Cabaret, Poi, Gambling, Rock climbing, Wood carving, Computer programming

Introduction: My name is Rueben Jacobs, I am a cooperative, beautiful, kind, comfortable, glamorous, open, magnificent person who loves writing and wants to share my knowledge and understanding with you.