I have a time-series chart but would like to skip Saturday and Sunday.
I have the scale setup so that the major labels repeat every seven
days. This allows me to show a Major gridline to separate the weeks
and minor dashed gridlines to separate the days. The x-labels only show
Monday (the first day of the week) and leave the other days blank.
This is great except for the extra room used for the dataless Sat/Sun.

In order to skip Saturday/Sunday (since I have no data for those days),
I've changed the Category (X) Axis to to Category instead of Auto or
Time-Scale. This does, in fact, skip the weekends but the gridlines
also change dramatically. Instead of one gridline for each day
(including Sat/Sun) I now have three per day. Directly above the day
is a dashed line and on either side of a particular day, two solid
lines.

Any ideas on how to have one gridline per day and only actual days with
data plotted?

- John