View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Garfiled
 
Posts: n/a
Default Updating a graph with 2 y axis

Hi Bill.
When I add a new series and then "plot series on" It gives me NEW COLOUM?
Regards

"Bill Martin" wrote:

Garfiled wrote:
Hi, I have a Graph which on 1 axis which has 2 datalines shown as a line.
and a 2nd axis which is a combined block.
I am trying to add a 3rd item to the 1st axis but cannot get it to show as a
line or on the same axis?


Right click on the graph line you want to change. and select "FormatDataSeries",
then on the "Axis" tab you can select to "PlotSeriesOn" which ever axis you want.

Bill