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
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 3/2/2010 11:56 AM, Chris Stammers wrote:
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

Thanks for your reply, Jon.

"Jon Peltier" wrote:

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/


On 3/2/2010 11:56 AM, Chris Stammers wrote:
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
.