2-Axis Column Graphs

  • Thread starter Thread starter Rita Brasher
  • Start date Start date
R

Rita Brasher

I have two sets of monthly data where the totals are very different
which makes it necessary for me to utilize both axis (without doing the
process John Peltier goes thru. LOL ) Right now I have them shown as a
column-line graph on two axis. How can I get the line to be a column
graph so the two columns are side by side for each month? When I change
the line to a column graph, it overlaps the existing column.

Any help is appreciated!

Rita Brasher
Project Engineer/ Int'l MIS and Analysis
FedEx Express
 
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
 
Ahh, thanks Andy :D Didn't think of it that way. Truly thought he was
just having fun! LOL
 
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!
 
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
 
Back
Top