Share via

excel graph - create a 15 minute interval in axis

Anonymous
2016-10-05T05:56:13+00:00

Hi I am trying to create a graph which shows time from 6 am to 6 pm with 15 minute intervals on the axis. Does anyone have the correct calculation? thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-10-05T07:39:47+00:00

    Hello,

    you need to use an XY scatter chart, since line charts don't show units smaller than a day on the x axis.

    Format the X axis and set the major unit to 0.010417, which is the numerical equivalent of 15 minutes. Note that with 15 minute increments, you need to make the chart about three screens wide, so all data labels show. You also may want to turn the axis labels 90 degrees.

    You can set the number format of the axis to "Linked to source" so it will show the same format as your source data.

    25 people found this answer helpful.
    0 comments