Hi,

Yes but then the style of the chart on the secondary axis is normal
different, as you already have.

It would be very confusing to have columns next to each other with
different scaling.

What are the 2 data sets? Volume, Sales, Amount ...

Cheers
Andy


Rita Brasher wrote:
OOps, sent too fast...
Honestly though, I thought that was for the purpose of using one Axis
with very differing numbers.
Thanks for the help!

Andy Pope wrote:

Hi,

Jon does not go through that process for the fun of it, I think :)
The reason for the work around is there is no built in way to do it.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info