| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
2-Axis Column Graphs
Ahh, thanks Andy :D 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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i make two column graphs into one? on one axis | Charts and Charting in Excel | |||
| changing x axis of column graphs | Excel Worksheet Functions | |||
| overlay two graphs with different x axis | Charts and Charting in Excel | |||
| Increasing X-axis Offset for graphs cutting x-axis | Charts and Charting in Excel | |||
| graphs with dynamic x-y axis | Charts and Charting in Excel | |||
Hybrid Mode
