Data Table Help

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
View Pivot Table Source data as a Data Table	InsomniacFolder	Microsoft Excel Misc	6	12th Apr 2010 05:17 PM
Convert an untyped Data Table to a typed Data Table	John Wright	Microsoft VB .NET	6	14th May 2009 08:48 PM
Lookup data in a variable table & retrieve data from a pivot table	Shawna	Microsoft Excel Worksheet Functions	3	10th Oct 2008 11:11 PM
auto fill data into one table based on data from a linked table	=?Utf-8?B?RnJlaWRh?=	Microsoft Access Forms	5	5th Sep 2007 06:29 PM
Retain data in table based on changed data in another table	James	Microsoft Access Forms	3	14th Jan 2004 04:23 PM