Bar Chart X Axis Values

[MK_QSL]

Please check enclosed file showing Trellis Bar Chart.

What I want is to show Bar Chart X - Axis Timing as 10:00, 11:00, 12:00 without changing the size of bar chart.

The Bar corresponding to 10:15, 10:30, 10:45 etc should be there but only bar chart should not show the name.

Hope my requirement is clear...

[rwunderlich · Accepted solution]

Treseco is on the right track, but I would use a calculated Dim like:

=dual(if(Minute(Time)=0, Time, ''), Time)

That will display blank on the axis unless it's the top of the hour.

-Rob

http://masterssummit.com

http://robwunderlich.com