View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
kippers kippers is offline
external usenet poster
 
Posts: 51
Default Adjust X Axis Scale to Months/Days or Hours?

Cheers Andy- is there any way of going down to hourly level of detail- the
drop downs only seem to go down to daily?


"Andy Pope" wrote:

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

kippers wrote:
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info