Changing order of series in line-column chart

T

Tim

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing order of series 2
How to change series plotting order without changing legend order? 6
Line Chart & Bar Chart Combined 2
Show Series Name 5
Convert Error Bars to Series and Colour 1
how to select multiple data series in a chart? 1
Stack Chart Help 1
How do I change the order of the line versus the marker for a scat 4

Top