How To Add Axis Title In Excel

Later you have created a nautical chart in Excel, what'due south the kickoff thing y'all ordinarily want to do with it? Make the graph look exactly the fashion y'all've pictured information technology in your mind!

In modern versions of Excel, customizing charts is like shooting fish in a barrel and fun. Microsoft has really made a large endeavour to simplify the procedure and identify the customization options within easy attain. And further on in this tutorial, yous volition learn some quick ways to add together and alter all essential elements of Excel charts.

• Add together the chart title
• Customize chart axes
• Add data labels
• Add, hide, movement or format chart legend
• Show or hide the gridlines
• Edit or hide data series in the graph
• Change the chart blazon and styles
• Alter the default chart colors
• Swap vertical and horizontal axes
• Flip an Excel chart from left to right

iii ways to customize charts in Excel

If you lot've had a adventure 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 nautical chart and become to the Chart Tools tabs (Blueprint and Format) on the Excel ribbon.
2. Right-click the nautical chart element you would like to customize, and choose the respective item from the context card.
3. Utilise the chart customization buttons that appear in the pinnacle right corner of your Excel graph when you click on it.

Fifty-fifty more than customization options can be found on the Format Nautical chart pane that appears on the right of your worksheet equally soon every bit you click More options… in the chart's context carte du jour or on the Chart Tools tabs on the ribbon.

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

Armed with this basic knowledge, permit's run across how y'all tin change different nautical chart elements to make your Excel graph await exactly the way you'd like information technology to await.

How to add championship to Excel chart

This department demonstrates how to insert the chart title in dissimilar Excel versions so that you know where the main chart features reside. And for the residue of the tutorial, nosotros will focus on the well-nigh recent versions of Excel.

Add title to chart in Excel 2019, 2016 and 2013

In these Excel versions, a chart is already inserted with the default "Chart Title". To alter the title text, simply select that box and type your title:

Y'all can also link the nautical chart championship to some cell on the sheet, and so that it gets updated automatically every fourth dimension the liked cell is updated. The detailed steps are explained in Linking axis titles to a sure cell on the sheet.

If for some reason the title was not added automatically, then click anywhere inside the graph for the Chart Tools tabs to appear. Switch to the Design tab, and click Add Nautical chart Chemical element > Chart Title > To a higher place Chart I (or Centered Overlay).

Or, you lot tin can click the Chart Elements button in the upper-right corner of the graph, and put a tick in the Chart Championship checkbox.

Additionally, you lot can click the arrow next to Chart Title and chose ane of the post-obit options:

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

For more than options, go to the Design tab > Add together Chart Element > Nautical chart Championship > More Options.

Or, you can click the Nautical chart Elements push and click Chart Title > More than Options…

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

Add title to chart in Excel 2010 and Excel 2007

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

1. Click anywhere within your Excel graph to actuate the Chart Tools tabs on the ribbon.
2. On the Layout tab, click Chart Championship > In a higher place Nautical chart or Centered Overlay.

Link the chart championship 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 nautical chart championship, you can either select the championship box and type the text you want, or you tin link the chart title to some prison cell on the worksheet, for case the tabular array 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 post-obit steps:

1. Select the chart title.
2. On your Excel canvass, 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 prison cell A1. You tin can also select two or more cells, e.g. a couple of column headings, and the content of all selected cells volition announced in the chart title.

Move the title inside the chart

If you want to move the title to a different place inside the graph, select it and drag using the mouse:

Remove the chart title

If you don't want whatsoever championship in your Excel graph, you tin delete it in two means:

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

Modify font and formatting of chart title

To change the font of the chart title in Excel, correct-click the title and cull Font in the context menu. The Font dialog window will pop up where you can choose different formatting options.

For more formatting options, select the title on your chart, go to the Format tab on the ribbon, and play with different features. For instance, this is how y'all can change the championship of your Excel graph using the ribbon:

In the same way, yous can modify the formatting of other chart elements such as centrality titles, centrality labels and nautical chart legend.

For more than information about nautical chart championship, please see How to add together titles to Excel charts.

Customizing axes in Excel charts

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

You can evidence or hide nautical chart axes past clicking the Nautical chart Elements button , then clicking the pointer next to Axes, and then checking the boxes for the axes yous want to prove and unchecking those you want to hide.

For some graph types, such as combo charts, a secondary centrality tin can exist displayed:

When creating 3-D charts in Excel, you tin make the depth axis to announced:

Yous can besides make dissimilar adjustments to the way that different axis elements are displayed in your Excel graph (the detailed steps follow below):

Add axis titles to a chart

When creating graphs in Excel, you can add together titles to the horizontal and vertical axes to assist your users sympathise what the chart data is about. To add together the centrality titles, practice the post-obit:

1. Click anywhere within your Excel chart, then click the Nautical chart Elements push button and check the Axis Titles box. If yous want to display the title just for one axis, either horizontal or vertical, click the arrow adjacent to Axis Titles and clear 1 of the boxes:
   
2. Click the axis title box on the chart, and type the text.

To format the axis championship, right-click information technology 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 endeavor different formatting options on the Format tab on the ribbon, every bit demonstrated in Formatting the nautical chart title.

Link axis titles to a certain jail cell on the sail

Every bit is the case with chart titles, you can link an axis championship to some prison cell on your worksheet to have it automatically updated every fourth dimension you edit the corresponding cells on the sheet.

To link an axis title, select it, then blazon an equal sign (=) in the formula bar, click on the prison cell you want to link the title to, and press the Enter key.

Change the axis scale in the chart

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

1. Select the vertical axis in your chart, and click the Chart Elements push .

2. Click the arrow side by side to Axis, then click More than options… This volition bring upwardly the Format Axis pane.

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

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

Because a horizontal axis displays text labels rather than numeric intervals, it has fewer scaling options that you can change. However, you can modify the number of categories to display betwixt tick marks, the order of categories, and the indicate where the two axes cross:

Alter the format of axis values

If you want the numbers of the value axis labels to brandish as currency, pct, time or in some other format, correct-click the axis labels, and cull Format Centrality in the context carte. On the Format Axis pane, click Number and choose one of the available format options:

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 meet the Number section in the Format Axis pane, brand certain yous'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 sympathise, yous tin can add data labels to display details nigh the data series. Depending on where y'all want to focus your users' attention, y'all can add together labels to i data series, all the series, or private data points.

1. Click the information series you want to characterization. To add a label to one data point, click that information point after selecting the series.
   
2. Click the Chart Elements button, and select the Data Labels option.

For instance, this is how we can add labels to i of the information serial in our Excel chart:

For specific chart types, such as pie chart, you tin can as well choose the labels location. For this, click the arrow next to Data Labels, and choose the choice you desire. To testify information labels inside text bubbles, click Data Callout.

How to alter information displayed on labels

To modify what is displayed on the data labels in your nautical chart, click the Chart Elements push > Data Labels > More than options… This will bring up the Format Information Labels pane on the right of your worksheet. Switch to the Label Options tab, and select the choice(s) you want under Label Contains:

If you want to add your own text for some data point, click the label for that data signal so click it again so that only this label is selected. Select the characterization box with the existing text and type the replacement text:

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

Information label tips:

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

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 before versions.

To hide the legend, click the Chart Elements button in the upper-right corner of the chart and uncheck the Legend box.

To move the chart fable to some other position, select the nautical chart, navigate to the Design tab, click Add Nautical chart Element > Fable and cull where to move the legend. To remove the legend, select None.

Another way to movement the legend is to double-click on information technology in the chart, then choose the desired fable position on the Format Fable pane under Legend Options.

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

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.

Microsoft Excel determines the about advisable gridlines blazon for your chart type automatically. For instance, on a bar chart, major vertical gridlines volition be added, whereas selecting the Gridlines option on a column nautical chart will add major horizontal gridlines.

To modify the gridlines type, click the arrow side by side to Gridlines, and and then choose the desired gridlines type from the list, or click More Options… to open up the pane with advanced Major Gridlines options.

When a lot of data is plotted in your chart, y'all may desire to temporary hide some information series and so that you lot could focus only on the about relevant ones.

To practice this, click the Nautical chart Filters push on the correct of the graph, uncheck the data serial and/or categories you desire to hide, and click Apply.

To edit a data serial, click the Edit Series button to the right of the information series. The Edit Series button appears every bit soon as you lot hover the mouse on a certain information series. This will also highlight the corresponding series on the chart, so that you lot could clearly meet exactly what chemical element y'all volition be editing.

Irresolute chart type and way

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

Alternatively, you lot can correct-click anywhere within the graph and select Change Chart Type… from the context menu.

To speedily change the style of the existing graph in Excel, click the Chart Styles button on the right of the chart and scroll downwardly to see the other style offerings.

Or, choose a different style in the Charts Styles group on the Design tab:

Changing chart colors

To alter the color theme of your Excel graph, click the Chart Styles button, switch to the Color tab and select one of the available colour themes. Your option volition be immediately reflected in the chart, and so y'all can decide whether it will await well in new colors.

To choose the colour for each data series individually, select the data serial on the nautical chart, get to the Format tab > Shape Styles group, and click the Shape Fill button:

How to swap X and Y axes in the chart

When y'all make a chart in Excel, the orientation of the data serial 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 fashion your worksheet rows and columns are plotted past default, you can easily swap the vertical and horizontal axes. To practise this, select the nautical chart, go to the Design tab and click the Switch Row/Cavalcade push button.

How to flip an Excel chart from left to right

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

Right click on the horizontal centrality in your chart and select Format Axis… in the context menu.

If you prefer working with the ribbon, go to the Pattern tab and click Add Nautical chart Element > Axes > More than Axis Options…

Either way, the Format Axis pane will prove up, y'all navigate to the Centrality Options tab and select the Categories in contrary order choice.

Apart from flipping your Excel nautical chart from left to right, you tin also alter the order of categories, values, or series in your graph, opposite the plotting order of values, rotate a pie chart to any bending, and more. The post-obit 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 form, 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 nautical chart based on information from several worksheets. And in the meanwhile, I encourage y'all to review the links at the stop of this article to acquire more.

You may likewise be interested in

How To Add Axis Title In Excel,

Source: https://www.ablebits.com/office-addins-blog/2015/10/29/excel-charts-title-axis-legend/

Posted by: steinmetzocas1943.blogspot.com

Share this post