Would need more detail but it sounds like you have a Line chart with Chart
Option | Axis setting as Automatic or Time Scale
In this case Day is the smallest unit
Use Chart Option | Axis and set to Category
But be aware that now the x-axis spacing will not be scaled
However, an XY chart will work as you need -- if I read your message
correctly
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ted Eden" <Ted wrote in message
...
How can I show hourly values in a diagram - now the minimum resolution
seems to be day