How do i plot a data set that has one data point missing

's Computer Specifications

's Computer Specifications

1) In the blank cell enter =NA() which shows as #N/A and is ignored by the
chart engine. Or if using formula use something like =IF(A1>0, B1/A1, NA())

2) Click chart; use Tools | Options; open Chart tab and specify how missing
data is to be treated.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"planet SA" <planet (E-Mail Removed)> wrote in message
news:BAD42AA8-7D65-4257-BE3A-(E-Mail Removed)...
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
show 3 sets of data per data point in a scatter plot	=?Utf-8?B?TWFyaWU=?=	Microsoft Excel Charting	6	19th May 2008 09:38 PM
How do I plot two columns of data as one data point/marker in a ch	=?Utf-8?B?VGltIEwgQ29sZSBIYWFu?=	Microsoft Excel Charting	1	1st Dec 2005 12:56 AM
scatter plot & label for a data point	=?Utf-8?B?c2hhYm5hbQ==?=	Microsoft Excel Charting	3	11th Apr 2005 06:37 PM
how do i plot last n data point	=?Utf-8?B?eHh4eGpvYW5uZQ==?=	Microsoft Excel Charting	2	8th Nov 2004 04:16 AM
how do i plot last n data point	=?Utf-8?B?eHh4eGpvYW5uZXh4eHgoOClpIGhvcGUgdSBhdmUg	Microsoft Excel Charting	0	7th Nov 2004 02:13 PM