Thread: changing axis
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Liz
 
Posts: n/a
Default changing axis

YEAH!!! I got it. Thanks for your help.

"Andy Pope" wrote:

Hi,

I don't think you can control this when adding extra data.

Once added right click and use the format to change the axis. Also use
the right click to change chart type.

Cheers
Andy

Liz wrote:
I'm running excel 2002. I have a 2 axis chart with lines and columns. When
I add a new series how do I tell it which axis the series is attached to. It
keeps putting them on the lines and I need to add the new series to the
columns


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info