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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com