0

I have a hourly data of a entire week in excel, and I want to plot it! But when I do so, in the x-axis appears the hours of the week (i.e, from 1 to 168), as it was expected. But I would prefer that it would just appear the days of the week, i.e., instead of the first 24h, it would appear just 'Monday'.

Thank you so much in advance!

PingP
  • 17
  • 5

1 Answers1

0

You can create an extra column which calculates the weekday from the datetime value. Just put this calculated weekday in one column next to the hourly data, and select this column as the x-axis.

Martijn van der Jagt
  • 524
  • 3
  • 13