I have created a month by month running total graph tracking participants in
a job program that I run. Is there a away to turn off cells until a specific
date so that they are not incorporated into the graph? For instance I have
participant information up until June, but all the months after June show my
current total as well. This may not make sense without seeing the graph.

You could incorporate dynamic charting. To do this, we need to setup a named
range that defines your x-axis (months to use).
Not sure how your data is setup, but you need to create a formula that
counts how many months you want to use (for now, lets say the result is 7).

If your x-axis data starts in A2 and goes down, go to Insert-Name-Define.
Give the range a memorable name (MyRange), and input this formula:
=OFFSET($A$2,0,0,7,1)
Click "add"
(note that the 7 is where you would either have a cell reference, or formula
calculating how many months you need.)
If your data runs horizontal starting in B1, change formula to:
=OFFSET($B$1,0,0,1,7)

Now, on your chart, go to Source Data, and for the x-axis, input this
='MyWorkbookName.xls'!MyRange

Now, as the area you defined in the named range changes in size, so too will
your graph.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DTrifone" wrote:

I have created a month by month running total graph tracking participants in
a job program that I run. Is there a away to turn off cells until a specific
date so that they are not incorporated into the graph? For instance I have
participant information up until June, but all the months after June show my
current total as well. This may not make sense without seeing the graph.