View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Changing order of series in line-column chart

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