Data Table Help
 

Excel 2003 - I have a line chart with a data table showing values by month. Also on the chart is a target line - not a trendline - the target line remains a constant value (since it is a target) so I do not need to show it's value on the data table but because I am plotting the line on my graph it is automatically showing up in my data table. Is there a way to take it off? I've tried adding data - merging the cells with the data - no dice. Is this even possible?

Thanks,
K


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Conditional looping incorporating the Greater Than functoid.
http://www.eggheadcafe.com/tutorials...onal-loop.aspx