 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / January 2007Adjust X Axis Scale to Months/Days or Hours?
When I right-click on the axis, I donlt seem to have the option of selcting days/months or hours for the scale of the graph. I can only enter integer values- any ideas?? Cheers Hi, You need to force the axis to be Time Series. Right click chart and pick Chart Options. On the Axis tab change the scale type from Automatic to Time Series. Cheers Andy > When I right-click on the axis, I donlt seem to have the option of selcting > days/months or hours for the scale of the graph. I can only enter integer > values- any ideas?? > > Cheers  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Cheers Andy- is there any way of going down to hourly level of detail- the drop downs only seem to go down to daily? > Hi, > [quoted text clipped - 10 lines] > > > > Cheers For Hours you would need to use the xy-scatter chart. Although the scale has Min and Max values you can enter dates and times. The values will then be converted to serial date values for you. So for example you could enter this values to get 12 hour intervals through the days in January. The values in brackets are what the chart converts them to when you re check the scale values. Min: 1/1/2007 (39083) Max: 31/1/2007 (39113) Major: 12:00 (0.5) Cheers Andy > Cheers Andy- is there any way of going down to hourly level of detail- the > drop downs only seem to go down to daily? [quoted text clipped - 13 lines] >>> >>>Cheers SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Nice one- thanks Andy > For Hours you would need to use the xy-scatter chart. > Although the scale has Min and Max values you can enter dates and times. [quoted text clipped - 27 lines] > >>> > >>>Cheers |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.