Formatting a Running Total Graph

[DTrifone]

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.

 

[Luke M]

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.