Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

Showing hour in a graph, not just days.

Steel Contributor

Hi,

 

I have a dataset where I would like to show each hour. But the line diagram only give the soption to show day, month, year.

 

What should I change? 

 

vise timer.png

 

Best regards

Geir

5 Replies

@Geir Hogstad 

That's with scatter chart.

Change your chart type to a scatter plot and set a custom number format for the x-axis to display hh:mm
Perfect, thank you
Perfect, thank you

@Geir Hogstad , you are welcome