2-Axis Column Graphs

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
 
A

Andy Pope

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
 
R

Rita Brasher

Ahh, thanks Andy :D Didn't think of it that way. Truly thought he was
just having fun! LOL
 
R

Rita Brasher

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!
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trendline Issues 4
Ok Andy (or anyone)... Dummy Series Help Needed 2
Combining a 2-D column graph and a 2-D line graph on the same char 3
Graphs: 2 Lines on secondary Y-axis? 1
Stacked Column with Secondary Axis 1
How do I specify x-axis data for a logarithmic line graph? 1
Exel - add vertical line to two axis graph 0
Line-Column 2 axes Help 1

Top