Changing order of series in line-column chart

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
Back
Top