Time intervals in graph in Excel 2016

[rafuk73]

Hello,

Could you please help me to put time intervals (30 mins each) in the attached graph. I knew how to do it in Excel 2010, but cant see the option in the Excel 2016.

What I would like to see in horizontal axis are 09:00:00, 09:30:00, 10:00:00 and so on to see the real time representation of the graph.

Many thanks.

[Kaper]

Hi,
Shouldn't it be a scatterplot, not line type one
It could be - I don't have handy 2010 installed - that in 2010 you could choose horizontal axis to be not label type but date type with units being hours or minutes.
But in 2019 version I'm currently using here, the shortses interval would be 1 day, so useless for you.
But see scatterplot in attachment

[rafuk73]

Thanks, Kaper!

One thing, the scattegraph would not update automatically if I change the values. It only updates after I right click and then choose the option Select Data and then click to close the Select Data window

Regards
rafuk