Time scales for charts
I have a spreadsheet that contain peoples hours on a daily basis under separate headings and I want to create a separate std column chart for each person that contains dates as the x axis with hours as the y axis. I am using hh:mm format to add the hours because I need a total number of hours for each day, with a total number of hours for each month further down the spreadsheet. However, the time slot is not quite I'm looking for. What I would like to do is see the time scale axis with major unit displayed as a whole hour, eg 01:00 to 15:00 depending on how many hours are completed each day. Currenty it jumps from 00:00 to 01:12 and so forth.
I have attached a copy of what I currently have as the chart.
Any help on how to change the scaling axis would be much appreciated.
Many thanks!
Last edited by floribunda; 03-16-2010 at 06:51 AM.
Hi,
Use 0.0416666666666667 as your major unit in the Y axis. That is the decimal equivalent of 1 hour.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
That works an absolute treat. Many thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks