Home Excel 2003 Charts Change The Order Of Components In A Chart
Search MS Office A-Z   |   Search Web Pages/ Design A-Z

Change The Order Of Components In A Chart

The trick here is selecting an entire data series. On a bar chart, for example, clicking any bar once selects the entire series. (A series is something like “dishwashers” in a chart showing how many dishwashers, refrigerators, and stoves each employee sold last year.) If you click the bar again, you’ll select just that bar, and formatting applies to it alone. With the series selected, click Format, Selected Data Series, and the Series Order tab. Here you can use the Move Up and Move Down buttons to shift the series order. The dialog box’s preview window shows how the changes will look.