Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to identify saturday and sunday automatically | Excel Discussion (Misc queries) |