How do I format the x axis on a "lines on 2 axes" chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
_______
 
Back
Top