Solution:
A chart is created in Excel 2007. How can I add an ordinate axis to the right of the chart?
Click the data series for which you want to display the ordinate axis. In this example, click the blue bar chart that displays the average temperature. On the format tab, click set content format.
The set Data Series Format dialog box is displayed.
In the series options, locate the series draw option, select the secondary axis option, and then click close. In this way, the ordinate axis with the average temperature is successfully drawn.
Although there are two vertical coordinate axes, the column charts are stacked together and cannot express the meaning accurately.
First, determine that the histogram of the average temperature has been selected. Click Change chart type on the design tab.
The modify chart type dialog box is displayed.
Select an example in the line chart you want, and click OK.
This completes.
