View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default pivot chart question

It depends on the chart type you've selected. If you've selected any of the
(unsavory) 3D flavors, you cannot mix chart types or axes. If you stick with
the 2D varieties you have a lot more flexibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mwam423" wrote in message
...
hi jon, appreciate the response. i'm working in excel 2003 and when i
click
on the axes tab, secondary isn't an option. am i outta luck on this one?


"Jon Peltier" wrote:

Double click a series, on the Axis tab of the dialog select Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______