View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default column chart stacks data when i add a secondary vertical axis

You can change the order either in the Series Order tab of the Format Series
dialog, or by changing the last number in the series formula.

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


"scott" wrote in message
...
Yes, that did finally do it, but the point that needs to be emphasized is
that the order the data is added to the graph, first the primary vertical
axis real data, second primary vertical axis dummy data, third secondary
vertical axis dummy data, and fourth secondary vertical axis real data.

Thanks for the help.