| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing order of series
I am using a line/column chart, Excel 2003, to plot two values (actual vs.
goal). I would like to change the order of the data series in the chart (change the bar to line and the line to bar). Excel help says to click on the data series, €śFormat€ť, €śSelected Data Series€ť, €śSeries Order€ť and then move the series by clicking on the €śMove Up€ť/€ťMove Down€ť button. However, when I follow these directions the €śMove Up€ť/€ťMove Down€ť buttons are grayed out since I can only select one series on the graph (and consequently only one series shows up in the series window). Am I missing something or is there another way of accomplishing this (other than changing the order these series appear on the worksheet)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| Changing a charts series order | Charts and Charting in Excel | |||
| Changing order of series appearing in the legend on xy scatter plo | Charts and Charting in Excel | |||
| Changing series information for approximately 60 series in a workb | Charts and Charting in Excel | |||
| Series order conflicts with line order | Charts and Charting in Excel | |||
Threaded Mode
