| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
column charts on two axis
I am trying to show a column chart on 2 axis. I have chosen the combination
line and column chart to get the 2 axis but when I change the line to a second column it puts the columns over the top of the first axis columns. How do I get them to be side by side? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
column charts on two axis
Have a look at: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jo" wrote in message ... I am trying to show a column chart on 2 axis. I have chosen the combination line and column chart to get the 2 axis but when I change the line to a second column it puts the columns over the top of the first axis columns. How do I get them to be side by side? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
column charts on two axis
Fantastic. Thanks
"Jo" wrote: I am trying to show a column chart on 2 axis. I have chosen the combination line and column chart to get the 2 axis but when I change the line to a second column it puts the columns over the top of the first axis columns. How do I get them to be side by side? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
column charts on two axis
"Jo" wrote: I am trying to show a column chart on 2 axis. I have chosen the combination line and column chart to get the 2 axis but when I change the line to a second column it puts the columns over the top of the first axis columns. How do I get them to be side by side? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
column charts on two axis
You need to use dummy series with no plotted values to move the visible
series to either side: Columns on Two Axes http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Julie wrote: "Jo" wrote: I am trying to show a column chart on 2 axis. I have chosen the combination line and column chart to get the 2 axis but when I change the line to a second column it puts the columns over the top of the first axis columns. How do I get them to be side by side? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
| Can you set dual axis side by side column charts? | Charts and Charting in Excel | |||
| Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
| charts....x and y axis | Charts and Charting in Excel | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
Linear Mode
