Hello all,
I need help making a chart to display a time period. I already have it mostly done but I seem to have to sticking points. One is I can't seem to adjust my time on the axis to be 6:00am to 12:00am. Two, my bar graph is not displaying right. To better illustrate I included the program with better instructions next to the problem area. Thank you for taking the time to look at it.
Format the X axis scale withOne is I can't seem to adjust my time on the axis to be 6:00am to 12:00am
minimum = 0.25
maximum = 0.583333333
To find out what a time value is in decimals, put the time into a cell, e.g. 6:00 am, and then format as General and it will display as 0.25. That's the value you need to enter in the axis scale tab.
Would you care to elaborate? There's so much going on in the spreadsheet that I would have to spend a whole hour to figure it all out. I'm sure it'll take you less time to point me to it.Two, my bar graph is not displaying right.
cheers
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.
The value for the time bar is too large. You need to calculate the time between start and finish.
M21: =TIME(MID(B7,6,2),MID(B7,8,2),0)-TIME(LEFT(B7,2), MID(B7,3,2),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks