Thread: How do I create a second "y" axis on the right?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Lost_in_Houston Lost_in_Houston is offline
external usenet poster
  
Posts: 1
Default How do I create a second "y" axis on the right?

This works great in Excel 1997-03, but how do you do this in Excel 2007?

Lost_in_Houston


"John Mansfield" wrote:

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".

----
Regards,
John Mansfield
http://www.pdbook.com

"Derrick" wrote:


Reply With QuoteReply With Quote