If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2-Axis Column Graphs
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 |
#2
|
|||
|
|||
2-Axis Column Graphs
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 "Rita Brasher" wrote in message ... 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 |
#3
|
|||
|
|||
2-Axis Column Graphs
Ahh, thanks Andy Didn't think of it that way. Truly thought he was
just having fun! LOL 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 |
#4
|
|||
|
|||
2-Axis Column Graphs
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 |
#5
|
|||
|
|||
2-Axis Column Graphs
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 |
Thread Tools | |
Display Modes | |
|
|