Clustered Column on 2 Axis...How?

[Andrew B]

Hi there,
I am looking for a little help here with a graph. I am trying to create
clustered column graph with 2 Y axis. But whenever I add the second axis it
stacks the 2 columns rather than leaving them sitting next to each other.

Some details are.

2 Products. Sales figures for each month. Product A sells in the thousands
whilst Product B sells in the hundreds.

So if I have one scale then Product B doesn't even appear on the chart.

Any ideas how I can do this without the columns stacking?

Cheers

Andrew B

 

[Andy Pope]

Hi Andrew B,

Yes it is possible, you just need to add some dummy data to space out
the columns. Create a chart using all 4 data series.
Then plot the last 2 series on the secondary axis.
Normally the 1 set of clustered bar would be obscured by the other.
That is while the second and first set of each is zero.

A B
M1 1 0 0 100
M2 2 0 0 200
M3 3 0 0 300

Hope this is clear enough.

Hi there,
I am looking for a little help here with a graph. I am trying to create
clustered column graph with 2 Y axis. But whenever I add the second axis it
stacks the 2 columns rather than leaving them sitting next to each other.

Some details are.

2 Products. Sales figures for each month. Product A sells in the thousands
whilst Product B sells in the hundreds.

So if I have one scale then Product B doesn't even appear on the chart.

Any ideas how I can do this without the columns stacking?

Cheers

Andrew B

--

Cheers
Andy

http://www.andypope.info