Using Excel 2003. Plotting a line-column chart using two columns of data
"Actual" & "Target". How can I change the order of the series, so that the
bar becomes the line and the line becomes the bar, without changing the
location of the data?
Excel help has me select a data series, click on "Format", "Selected Data
Series", "Series Order" and use the "Move Up"/"Move Down" buttons.
However, these buttons are grayed out (since I can only select one series
there is only one series showing in the "Series Order" window).
What am I missing? Or, is there another way of accomplishing this?

Thank you,
Tim

See your other post.

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


"Tim" wrote in message
...
Using Excel 2003. Plotting a line-column chart using two columns of data
"Actual" & "Target". How can I change the order of the series, so that
the
bar becomes the line and the line becomes the bar, without changing the
location of the data?
Excel help has me select a data series, click on "Format", "Selected Data
Series", "Series Order" and use the "Move Up"/"Move Down" buttons.
However, these buttons are grayed out (since I can only select one series
there is only one series showing in the "Series Order" window).
What am I missing? Or, is there another way of accomplishing this?

Thank you,
Tim