Line chart: Dates in uneven intervalls on x-achsis

[gdavids]

'Supplementary' questions: Is there a clever way to make excel recogniz
that '3 months' stands for '0.25 years', and '6 months' stands for '0.
years'?

I know, this is only cosmetics. Nevertheless it would be interesting


Gil

 

[Jerry W. Lewis]

You could use a helper column that divides months by 12 to scale as years.

Jerry

 

[Jon Peltier]

Gill -

You can make an axis with whatever arbitrary spacing and labels you want, using a
helper series:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______