How do I create a second "y" axis on the right?

  • Thread starter Thread starter Guest
  • Start date Start date
Derrick,

Create a simple line chart as an example with the following data:

Ser1 Ser2
a 1 4
b 2 3
c 3 4

In the clart plot area, double-click on the series called "Ser2". It should
be the higher line of the two series. In the Format Data Series dialog box,
go to the Axis tab. Choose the option "Plot series on: Secondary axis".
 
This works great in Excel 1997-03, but how do you do this in Excel 2007?

Lost_in_Houston
 
Hi,

The principal is the same just the UI is different.

Create the chart with the 2 series.
Select the series called "Ser2".
On the Layout or Format tab use the Format Selection within the Current
Selection group. On the Series Option tab select Secondary axis.

Cheers
Andy
 
OK, what if I want a second y-axis but it's essentially the same as the
original y-axis, only in a different format? In other words, I don't actually
have two columns of data, I just want to represent the axis in two different
ways, one on the left and one on the right.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
How do I put words as the Y axis values? 0
Make Y-axis values correspond to x- axis value 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
How to add another y-axis range into chart? 1
How can I make a scatter plot graph with a category x-axis? 0
Coordinate secondary y axis to primary y axis 2

Back
Top