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
> .
>