Then from layout>Axes> Secondary Horizontal Axis>default Axis, what I get is secondary horizontal value axis. This does not serve the purpose. It should take secondary horizontal category axis with values of 0.5 at right end and 1 at mid-point of the stacked column. Here are the steps of adding a secondary axis to this chart. 1) Select the data series that you want to add to the secondary axis. I choose the Average Sales Price data series as I want to show this data series on the secondary axis. To select a data series, just click on any data point of the data series. Excel already suggests a line, so the only thing I need to do is tick the secondary axis box. You can see this is a much simpler way to add a secondary axis. Finally, notice the secondary axis is an ordinary value axis. The axis options area in the Format Task pane includes all standard value axis settings.
Add Secondary Axis Excel Mac 2011
Sometimes just one Value axis is not enough! Of course that observation is only true if your data demands a second axis. Our example data for this tutorial pertains to the average temperature and rainfall in London across the 12 calendar months of a year. Figure 1 below, shows a chart that depicts this data from January to December. The temperature is depicted in Celsius and the rainfall is in millimeters.
What you should note carefully is that the value range of temperature spans between 30 and 70, whereas the range for rainfall is in between 0 to 12 (approximately). A chart that results from this data doesn't live up to the comparison, it's almost like, we are comparing items that cannot be compared! Figure 1: Chart with two Data Series To help your audience comprehend this data better, you could create two charts, but that’s an overkill since there’s a better, more elegant solution. You should span this data on two Value axes within the same chart, one for the temperature and the other for the rainfall.
In this tutorial, you are going to learn how to add a Secondary Value axis to your charts to overcome this kind of problem. Tip: To learn more about axes, refer to our tutorial. Follow these steps to get started: • Open your presentation and navigate to the slide that contains your chart. Within the chart, to which you want to add a second Value axis. Right-click (or Ctrl+click) this series to access the context menu, as shown Figure 2. From the context menu, choose the Format Data Series option (refer to Figure 2 again). Figure 2: Format Data Series option selected • This summons the Format Data Series dialog box that you can see in Figure 3, in this dialog box, select the Axis option within the sidebar.
Next select the radio button in front of the Secondary axis option, as shown highlighted in red within Figure 3. Figure 3: Secondary axis option selected for one of the series • This adds a secondary Value axis that maps your selected series, as shown in Figure 4.