Hide data points prior to a certain date

R

Rachel Garrett

I have a line chart with three series over time. One series represents
actual values. For future dates, I made a formula return "#N/A" so
that they won't be plotted.

For one of the other lines, I would like to do something similar for
*past* dates up to March 2008. When I change the source data to start
at the March 2008 value, of course this skews the graph and puts the
March 2008 value where the graph starts, at November 2007. I can't do
the #N/A trick, since other data depends on these values.

I would be happy to just right-click and hide the November through
March data points manually. However, the three data series overlap at
many places, and it's impossible to just pick out the ones I want.

Any suggestions?

Thanks,
Rachel
 
A

Andy Pope

Hi,

Sounds like you need another column of data that uses the NA() approach
for past data so the line beings in March 2008 even though the axis
begins November 2007. Then the other series can use the past data.
Then change the data used for that series to the new helper column.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top