Skipping Saturdays and Sunday
 

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

Skipping Saturdays and Sunday
 

John -

You have to adjust the Categories between Ticks and Categories between
Labels items on the Scale tab of the Format Axis dialog. Then note that
Major gridlines occur at each category, not at each label. Minor gridlines
occur within each category, pretty useless.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John Michl" wrote in message
oups.com...
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

Skipping Saturdays and Sunday
 

Thanks, Jon.

I was afraid of that. I was using the minor gridlines to differentiate
for the days within the week and the major gridlines to show the
begining of each week. I was able to format each type of line in a
different way so that the start of week would stand out. As you
mentioned, the minor gridlines when using Categories are pretty
useless.

Thanks again.

- John


Jon Peltier wrote:
John -

You have to adjust the Categories between Ticks and Categories between
Labels items on the Scale tab of the Format Axis dialog. Then note that
Major gridlines occur at each category, not at each label. Minor gridlines
occur within each category, pretty useless.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"John Michl" wrote in message
oups.com...
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