Charting with empty columns in between

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 ?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

charting time 10
Charting with irregularly spaced x-axis 1
type mismatch error in macro in excel 0
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
countig of nonblank cells with speciffic condition 3
Charting 3
Macro that delets empty cells between cells with text 3
Word Error Message: This file is corrupt and cannot be opened 1

Top