Can we break a chart line

I have a line chart which describe the number of absent students every week.
There is summer vocation during a year (week 27th to week 39th)
I want to the line break up when summer vocation.
Can we break line where summer vocation?As I understand your problem you have dates plotted along the X-axis and your
chart shows the dates during the summer vactaion with data points of zero
being charted during that period (assuming that the minum value for the
Y-axis is set at zero). One sulution that you can use is to force the reurned
the data to have minus values during the summer vacation. That way the data
points are invisible because they are off the chart. You can force the minus
values in a number of ways.
There may be other solutions but hopefully this will help.
"ad" wrote:
> I have a line chart which describe the number of absent students every week.
> There is summer vocation during a year (week 27th to week 39th)
> I want to the line break up when summer vocation.
> Can we break line where summer vocation?
>
>|||Thank,
I have filtered out the 27th week to 39th weeks,So there are no value
between 26th week and 40 weeks.
But there is still a line between 26th week and 40 week.
I want that there are not any line between 26th week and 4o weeks.
Can I do that?
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:A4567ECA-D3C0-4C5B-A870-A252D35338A2@.microsoft.com...
> As I understand your problem you have dates plotted along the X-axis and
your
> chart shows the dates during the summer vactaion with data points of zero
> being charted during that period (assuming that the minum value for the
> Y-axis is set at zero). One sulution that you can use is to force the
reurned
> the data to have minus values during the summer vacation. That way the
data
> points are invisible because they are off the chart. You can force the
minus
> values in a number of ways.
> There may be other solutions but hopefully this will help.
> "ad" wrote:
> > I have a line chart which describe the number of absent students every
week.
> >
> > There is summer vocation during a year (week 27th to week 39th)
> >
> > I want to the line break up when summer vocation.
> >
> > Can we break line where summer vocation?
> >
> >
> >|||I don't think that you can simply not chart the summer vacation period (break
the line) as long as this period is displayed. Thus my suggestion to force
the data points to a negative value show that they do not show up. Note that
a side result of this is that the charted line will appear to drop off the
chart at the beginning of the summer and then rise back up after the summer
break is over. Similar to charting values that are higher than a maximum
value that you set for the Y-axis.
"ad" wrote:
> Thank,
> I have filtered out the 27th week to 39th weeks,So there are no value
> between 26th week and 40 weeks.
> But there is still a line between 26th week and 40 week.
> I want that there are not any line between 26th week and 4o weeks.
> Can I do that?
>
>
> "B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> :A4567ECA-D3C0-4C5B-A870-A252D35338A2@.microsoft.com...
> > As I understand your problem you have dates plotted along the X-axis and
> your
> > chart shows the dates during the summer vactaion with data points of zero
> > being charted during that period (assuming that the minum value for the
> > Y-axis is set at zero). One sulution that you can use is to force the
> reurned
> > the data to have minus values during the summer vacation. That way the
> data
> > points are invisible because they are off the chart. You can force the
> minus
> > values in a number of ways.
> >
> > There may be other solutions but hopefully this will help.
> >
> > "ad" wrote:
> >
> > > I have a line chart which describe the number of absent students every
> week.
> > >
> > > There is summer vocation during a year (week 27th to week 39th)
> > >
> > > I want to the line break up when summer vocation.
> > >
> > > Can we break line where summer vocation?
> > >
> > >
> > >
>
>