Prev: How do I make a graph with 2-cycle X 3-cycle log-log graph paper?
Next: How To Chart A Formula in Excel 2007
From: ARD on 17 Dec 2009 05:21
Let's say the data is

Particulars Frequency

q 5
w -
e 6
r 7

While drawing a chart, it should not show wth column when it is 0, otherwise
it should take it into consideration. How ?
From: Bernard Liengme on 17 Dec 2009 09:45
Replace the empty cell by =NA() which displays as #N/A and is ignored by the
chart engine
OR
Click on the chart and open (in Excel 2003) Tools | Option | Chart and
specify how empty cells are to be treated. Similar option in Excel 2007
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"ARD" <ARD(a)discussions.microsoft.com> wrote in message
news:290225CC-6906-4CE8-8D91-6E77BE331703(a)microsoft.com...
> Let's say the data is
>
> Particulars Frequency
>
> q 5
> w -
> e 6
> r 7
>
> While drawing a chart, it should not show wth column when it is 0,
> otherwise
> it should take it into consideration. How ?

 | 
Pages: 1
Prev: How do I make a graph with 2-cycle X 3-cycle log-log graph paper?
Next: How To Chart A Formula in Excel 2007