Chart Issue - Excel 2003

[Chris Stammers]

Hello,

I have a chart that I need to build that uses a second category axis. I need
to plot the following data in the following order:

Actual Annual Premium
Budget Annual Premium
Actual Sales
Budget Sales
Actual Premium Collected
Budget Premium Collected

The actual and budget data is listed in 2 different tabs, with 12 columns -
one for each month. The Primary axis is the monetary value; the secondary
axis is the volume. I need to show the data in the order listed above but no
matter what order I place the data into the chart, I can't get the bars to
run in this order. I have tried adjusting the overlap and gap widths but that
hasn't worked either.

Any ideas?

Many thanks.
Chris

 

[Jon Peltier]

Excel has some internal rules regarding order of data in a chart legend.
Legend entries are grouped by axis and also by chart type.

- Jon

 

[Chris Stammers]

Thanks for your reply, Jon.

Excel has some internal rules regarding order of data in a chart legend.
Legend entries are grouped by axis and also by chart type.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/



.