I have a chart that has a line that measures the amount of items done and a
line with the target amounts. I have the chart showing the # of items on the
left and the date along the bottom. I have made it so the line goes to the
current date and stops, kind of.

This is were my problum is, I don't want the line dropping down to zero for
the rest of the days of the year and i don't want it to stay at that amount
till the end.

Can i make it so the line just stops at a certain point with out continuing
with the "target line"?

In article <B5D69E28-FB1C-4304-97C4-(E-Mail Removed)>,
(E-Mail Removed) says...
> I have a chart that has a line that measures the amount of items done and a
> line with the target amounts. I have the chart showing the # of items on the
> left and the date along the bottom. I have made it so the line goes to the
> current date and stops, kind of.
>
> This is were my problum is, I don't want the line dropping down to zero for
> the rest of the days of the year and i don't want it to stay at that amount
> till the end.
>
> Can i make it so the line just stops at a certain point with out continuing
> with the "target line"?
>
Make sure that the cells that represent the values for the rest of the year
are either empty (really empty not just looking empty because of formatting
or a formula that returns a ""). If they contain a formula, replace the ""
with NA().

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions