Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I format the x axis on a "lines on 2 axes" chart?
I am using a custom type chart called "lines on 2 axes" where there is one x
axis and two y axes. Is there any way to format the scaling on the x axis? Specifically, I have time points on my x axis that are not evenly spaced as far as time goes, but Excel plots these time points equal distances away, regardless of how much time (hours) there are between time points. Any way to fix this? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I format the x axis on a "lines on 2 axes" chart?
Don't use the built in custom chart types. If you have numerical X data,
make an XY chart. You can choose an option that shows lines connecting the points. Double click one of the series, and on the Axis tab, select Secondary. Voila! An XY chart on two axes, with an X axis you can actually adjust. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Becky B" <Becky wrote in message ... I am using a custom type chart called "lines on 2 axes" where there is one x axis and two y axes. Is there any way to format the scaling on the x axis? Specifically, I have time points on my x axis that are not evenly spaced as far as time goes, but Excel plots these time points equal distances away, regardless of how much time (hours) there are between time points. Any way to fix this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make secondary axis in bar chart | Charts and Charting in Excel | |||
In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
Secondary Axis chart | Charts and Charting in Excel | |||
Disappearing Chart Axis | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel |