enheder på x-akse med datoer

Fra help:

When you create a chart from worksheet data that uses dates, and the dates make up the category (x) axis in the chart, Microsoft Excel automatically uses a time-scale category axis.

...

Excel initially sets the time-scale base units (days, months, or years) according to the smallest difference between any two dates in the data. For example, if you have data for stock prices where the smallest difference between dates is seven days, Excel presets the time-scale base unit to days.

You can change the base unit to months to see the performance of the stock over a shorter or longer period of time, as in the first chart in the example. To change the base unit, click the axis, click Selected Axis on the Format menu, and then click the options you want on the Scale tab.


Men der er ikke "time-scale" på min x-akse

Fandt løsning, lavede nyt diagram og tvang det til at være timescale