software

We have a chart with 2 data series - Budget amp; Actual. We want to show all 12
months of the budget, but only the year-to-date months of the actual. The
problem is the data cells for the future actual amounts have formulas in them
so the chart use the result and plots the line. We do not want to delete the
data (which will require manual input each month, we just want the actual
data series line to not show for the future periods. We tried using IF
statements with 0, quot;quot;, quot; quot; and an alpha character, but these have not worked.
--
Jeff

Hi Jeff:
You can set up your actual data as a dynamic named range series, using the
OFFSET function. Many MVPs give tutorials how to do this on their websites,
see for instance:
www.tushar-mehta.com/excel/ne...rts/index.html
www.stfx.ca/people/bliengme/e...ps.htm#Dynamic
peltiertech.com/Excel/Charts/Dynamics.html
www.contextures.com/xlNames02.html

GL,
Henk
quot;Jeff Bremerquot; wrote:

gt; We have a chart with 2 data series - Budget amp; Actual. We want to show all 12
gt; months of the budget, but only the year-to-date months of the actual. The
gt; problem is the data cells for the future actual amounts have formulas in them
gt; so the chart use the result and plots the line. We do not want to delete the
gt; data (which will require manual input each month, we just want the actual
gt; data series line to not show for the future periods. We tried using IF
gt; statements with 0, quot;quot;, quot; quot; and an alpha character, but these have not worked.
gt; --
gt; Jeff