Chart Issue - Excel 2003


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
 
Ad

Advertisements

J

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
 
Ad

Advertisements

C

Chris Stammers

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/



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top