Change excel graph axis label how to#
Change excel graph axis label plus#
Change excel graph axis label series#

Click in the beginning of the Y axis title and delete the generic title.

Using the Home ribbon, change the font of the axis title to Arial, Bold, size 11.

(See Figure 4.32)įigure 4.32 Selecting a Title for the Y Axis

On the Design tab on the ribbon select the Add Chart Element button, then Axis Titles, then Primary Vertical.

Click anywhere on the Grade Distribution Comparison chart in the Grade Distribution worksheet to activate it.

Change excel graph axis label how to#

The following steps explain how to add titles to the X and Y axes to define these numbers and categories: For example, by looking at the Grade Distribution Comparison chart, it is not clear what the percentages along the Y axis represent.

Titles for the X and Y axes are necessary for defining the numbers and categories presented on a chart.

Select any of the available formatting commands.

Click either the Home tab or right click to activate the appropriate formatting pane.

Click and drag the legend so the top of the legend aligns with the 35% line next to the plot area (see Figure 4.29).

Change excel graph axis label plus#

Move the legend by placing your cursor – shaped like a little plus sign with four arrows – on the edge of the selection box.Select Right in the Legend Position options.Right click the legend on the Grade Distribution Comparison chart and select Format Legend.The following steps explain how to add these formats: Similar to the how we formatted the X and Y axes, we can format these items by activating them and using the formatting commands in the Home tab or the Format pane. The next items we will format on the Grade Distribution Comparison chart are the chart legend and title. Click the Close button in the Format Axis pane.Select a number format and set decimal places on the right side of the Format Axis dialog box.Click Number from the list of options on the left side of the Format Axis dialog box.Click the Format Selection button in the Current Selection group of commands.Click the Layout tab in the Chart Tools section of the ribbon.Click anywhere along the X or Y axis to activate it.Click the Close button at the top of the Format Axis pane.The Format Axis pane should match Figure 4.28. 05 to make the differences in the columns more dramatic. Click in the Decimal places input box and change the value to 1.

The commands in this section of the Format Axis pane are used to format numbers that appear on the selected axis of the chart. Click Number from the list of options.Right click the vertical (value) axis.Next we want to make some changes to the percentage numbers on the Y (vertical) axis. The final appearance of the axes is shown in Figure 4.27 Formatted X & Y Axes.Click on the chart title and repeat steps 2 and 3, but set the Size to 14.Click anywhere along the Y axis to activate it and repeat steps 2 and 3.Change the font to Arial, the Font Style to Bold, and the Size to 11 (see Figure 4.26).Switch to the Grade Distribution worksheet and click anywhere along the X axis (horizontal axis) of the Grade Distribution Comparison chart.The following steps demonstrate a few of these formatting techniques on the Grade Distribution Comparison chart: Although adjusting the font size, style, and color are common, many more options are available through the Format Axis pane. There are numerous formatting commands we can apply to the X and Y axes of a chart. We will demonstrate these formatting techniques using the column chart and stacked column chart from the previous section. These notes are also helpful in answering questions if you are using charts in a live presentation. For example, you can add footnotes explaining the data source as well as notes that clarify the type of numbers being presented (i.e., if the numbers in a chart are truncated, you can state whether they are in thousands, millions, etc.).

However, formatting techniques also help you qualify and explain the data in a chart. Formatting commands are applied to a chart for the same reason they are applied to a worksheet: they make the chart easier to read. You can use a variety of formatting techniques to enhance the appearance of a chart once you have created it.

Change excel graph axis label series#

Employ series lines and annotations to enhance trends and provide additional information on a chart.

Apply formatting commands to the chart area and the plot area of a chart.

Apply labels and formatting techniques to the data series in the plot area of a chart.

Assign titles to the X and Y axes that clarify labels and numeric values for the reader.

Enhance the visual appearance of the chart title and chart legend by using various formatting techniques.

Apply formatting commands to the X and Y axes.