Format X-Axis with Base Unit = Hour(s)

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I dealing with hourly data I need to graphically present
the data in hourly intervals. MS Excel only allows for
Base unit selections of Day(s), Months(s) and Year(s).
Is there a solution available to plot hourly indexed
values without the graphical scaling on hourly intervals?
 
[This followup was posted to microsoft.public.excel.charting with an
email copy to Joe.
Please use the newsgroup for further discussion.]

The easy out is to use a XY Scatter chart.

The more complicated solution is to use a XY Scatter chart with an
additional (dummy) series that represents the values you want to show
on the x-axis. Plot this series, show its x-values as datalabels, and
hide the display of values along the real axis.

For an example of how to use a dummy series as an axis label, see the
'Flexible Log Scale' tutorial on my web site. The same principle that
applies to that tutorial applies to the x-axis.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top