Charting with empty columns in between

  • Thread starter Thread starter ARD
  • Start date Start date
A

ARD

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 ?
 
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
 
Back
Top