how can I make a column chart's x-axis interval be less than 1 day. excel automatically sets the major/minor units to days/moths/years - I need hours.... which is not an option....

figured that out finally...

what about column charts ignoring blank cells?? or at least have the chart formatted so that the maximum x-value stops at the last y-point with data?

[Edited on June 8, 2009 at 7:41 PM. Reason : .]

6/8/2009 7:36:30 PM

Gonna be awhile until they get around to releasing that one.

6/8/2009 9:20:51 PM

hehe

6/8/2009 9:23:35 PM

meh. scatter plots do it, don't see why column charts couldn't

6/9/2009 7:20:04 AM