| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis on 0 on Line-Column on 2 Axes
Is there a way on a Line-Column on 2 Axes chart to have the 0 value on both
the bar and line axes be straight across from each other even though the bar chart is in 1,000s and the line axes is in single digits and has negative numbers? Only way I can figure is to put negative numbers in the bar axis as well. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
X axis on 0 on Line-Column on 2 Axes
Try this:
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Supe" wrote in message ... Is there a way on a Line-Column on 2 Axes chart to have the 0 value on both the bar and line axes be straight across from each other even though the bar chart is in 1,000s and the line axes is in single digits and has negative numbers? Only way I can figure is to put negative numbers in the bar axis as well. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column-line chart on two axes | Charts and Charting in Excel | |||
| How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
| Line - column on 2 axes | Charts and Charting in Excel | |||
| How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
| Line-Column 2 axes Help | Charts and Charting in Excel | |||
Hybrid Mode
