Hi is there a way to create a time scale chart measured in hours and minutes.
Help says only months and days but thought there might be a way around it
Thanks
Hi is there a way to create a time scale chart measured in hours and minutes.
Help says only months and days but thought there might be a way around it
Thanks
I might be misunderstanding your question, but if you simply want a chart with time in hours:minutes as the x-axis, that's not a problem. In fact, you should be able to use whatever you like for the x-axis by designating that column as the source data for the x-axis labels in the chart wizard. If you wanted your x-axis origin to be 0:00 and go up in multiples of 5 minutes, you would put this in your first cell next to your y-axis data:
0:00
this in your next:
0:05
then fill down as far as you need. The x-axis will then be 0:00 0:05 0:10 0:15...
Is that what you're looking for?
Hi many thanks now sorted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks