Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hours on X axis
I am trying to use the following hours to display on the X axis labels in a
chart. The chart is displaying hours and minutes. How can the hours only be displayed on (X) asix labels? Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00 -- RV |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hours on X axis
Format Axis/ Number/ Custom:
hh -- David Biddulph "RV" wrote in message ... I am trying to use the following hours to display on the X axis labels in a chart. The chart is displaying hours and minutes. How can the hours only be displayed on (X) asix labels? Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00 -- RV |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hours on X axis
Thank you David. I changed to custom hh and getting 7:12 or 2:24 instead of
7:00 and 2:00. Is there any way around it? -- RV "David Biddulph" wrote: Format Axis/ Number/ Custom: hh -- David Biddulph "RV" wrote in message ... I am trying to use the following hours to display on the X axis labels in a chart. The chart is displaying hours and minutes. How can the hours only be displayed on (X) asix labels? Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00 -- RV |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hours on X axis
Double click the axis, and on the Scale tab, enter the values you want in
the min, max, and major unit boxes. Use a time format of h:mm or h:mm:ss to enter the values, and Excel will convert them to the decimal equivalents for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "RV" wrote in message ... Thank you David. I changed to custom hh and getting 7:12 or 2:24 instead of 7:00 and 2:00. Is there any way around it? -- RV "David Biddulph" wrote: Format Axis/ Number/ Custom: hh -- David Biddulph "RV" wrote in message ... I am trying to use the following hours to display on the X axis labels in a chart. The chart is displaying hours and minutes. How can the hours only be displayed on (X) asix labels? Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00 -- RV |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hours on X axis
It appears that the actual data for the hours is charted, not the actual
hours. I can not change the scale to display the hours. I hope I have described the situation better. Day Max Hours Actual Hours Data 1 147 14:00 0.583333333333333 2 148 15:00 0.625 3 166 14:00 0.583333333333333 4 182 19:00 0.791666666666667 5 219 16:00 0.666666666666667 6 170 15:00 0.791666666666667 7 156 15:00 0.625 -- RV "Jon Peltier" wrote: Double click the axis, and on the Scale tab, enter the values you want in the min, max, and major unit boxes. Use a time format of h:mm or h:mm:ss to enter the values, and Excel will convert them to the decimal equivalents for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "RV" wrote in message ... Thank you David. I changed to custom hh and getting 7:12 or 2:24 instead of 7:00 and 2:00. Is there any way around it? -- RV "David Biddulph" wrote: Format Axis/ Number/ Custom: hh -- David Biddulph "RV" wrote in message ... I am trying to use the following hours to display on the X axis labels in a chart. The chart is displaying hours and minutes. How can the hours only be displayed on (X) asix labels? Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00 -- RV |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hours on X axis
0.58333333333 is how Excel stores 14:00; 14:00 is how Excel displays
0.58333333333 using a number format of "H:MM". What kind of chart have you made? If the times are on the X axis of a line chart, they may not work the way you expect, because a line chart does not use values, only labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "RV" wrote in message ... It appears that the actual data for the hours is charted, not the actual hours. I can not change the scale to display the hours. I hope I have described the situation better. Day Max Hours Actual Hours Data 1 147 14:00 0.583333333333333 2 148 15:00 0.625 3 166 14:00 0.583333333333333 4 182 19:00 0.791666666666667 5 219 16:00 0.666666666666667 6 170 15:00 0.791666666666667 7 156 15:00 0.625 -- RV "Jon Peltier" wrote: Double click the axis, and on the Scale tab, enter the values you want in the min, max, and major unit boxes. Use a time format of h:mm or h:mm:ss to enter the values, and Excel will convert them to the decimal equivalents for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "RV" wrote in message ... Thank you David. I changed to custom hh and getting 7:12 or 2:24 instead of 7:00 and 2:00. Is there any way around it? -- RV "David Biddulph" wrote: Format Axis/ Number/ Custom: hh -- David Biddulph "RV" wrote in message ... I am trying to use the following hours to display on the X axis labels in a chart. The chart is displaying hours and minutes. How can the hours only be displayed on (X) asix labels? Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00 -- RV |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |