Chart Issue - Excel 2003

  • Thread starter Thread starter Chris Stammers
  • Start date Start date
C

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
 
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
 
Thanks for your reply, Jon.

Jon Peltier said:
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/



.
Click to expand...
 
Back
Top