Creating a secondary vertical axis for charts in Microsoft Office 2007 or Office 2010

Sometimes when you chart data, you are not really comparing like with like, and may want two vertical axes, for example if you are comparing temperature with rainfall.

Climate in Buenos Aires
Month

Temperature (deg C)

Rainfall

January

30

119

February

29

118

March

26

134

April

23

97

May

19

74

June

16

63

July

15

66

August

17

70

September

19

73

October

22

119

November

25

109

December

26

105

Create the chart in the usual way.

I now decide to have a line v column chart.

Clicking one column in the chart selects all columns in that series. On the Chart Tools Design tab, click Change Chart Type, select one of the line chart types, then click OK.

I would now like rainfall to be shown on a secondary vertical axis. Select the line, then on the Chart Tools Layout tab, click Format Selection; the Format Data Series dialog box opens.

Select Secondary Axis from the Series Options section. Click Close.

The rainfall is plotted on the secondary vertical axis.

For more details about our Microsoft Office training London, UK, please visit http://www.jmdtraining.co.uk/microsoft-office-training.

For more details about our Microsoft Office training Sydney, Australia, please visit http://www.jmdtraining.com.au/microsoft-office-training.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Office 2007 and 2010, Microsoft PowerPoint and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s