making a Bar Chart that leaves out Blank Cells

[Casey]

Hello,
I have a column of values that I would like to turn into a bar chart, but there are also numerous blank cells interspersed. Does any one know of a way to make the bar chart without including the blank cells.
Any suggestions would be greatly appreciated
thanks
Casey

[Aladin Akyurek]

On 2002-05-14 12:58, Casey wrote:
Hello,
I have a column of values that I would like to turn into a bar chart, but there are also numerous blank cells interspersed. Does any one know of a way to make the bar chart without including the blank cells.
Any suggestions would be greatly appreciated
thanks
Casey

Replace blank cells with #N/A.

[Casey]

Hello,
I tried to dothe #N/A thing, but it didnt seem to make a difference. When I use the chart wizard it still shows all of the rows.
am I using it right, I just fill all the blanks with the #N/A, select the column and run the wizard.
thanks
Casey

[Aladin Akyurek]

On 2002-05-14 13:28, Casey wrote:
Hello,
I tried to dothe #N/A thing, but it didnt seem to make a difference. When I use the chart wizard it still shows all of the rows.
am I using it right, I just fill all the blanks with the #N/A, select the column and run the wizard.
thanks
Casey

Hmmm...

I just applied Adv Filter with "Filter the list, in place" checked to a range of numbers in A in order to filter out blank cells. The Bar chart appears to skip blanks.

Is this a viable option?

[Casey]

This appears to work.
Thank you for your help
Casey

[Casey]

Actually that didnt work, I was just using the "unique records only" selection, and it turns out that I have quite a few repeats , so I cant do that.
Idont know if there is something simialr or if that was what I was supposed to do.
Thanks
Casey

[Aladin Akyurek]

On 2002-05-15 07:14, Casey wrote:
Actually that didnt work, I was just using the "unique records only" selection, and it turns out that I have quite a few repeats , so I cant do that.
Idont know if there is something simialr or if that was what I was supposed to do.
Thanks
Casey

I had something different in mind than "Unique records only."

Suppose that A4:A14 has the following sample:

{"Values";
5;
4;
3;
5;
"";
"";
6;
4;
5;
7}

In A2 enter:

=LEN(A5)>0

Activate A5.
Activate Data|Advanced Filter.
Check Filter the list, in-place.
Enter $A$2:$A$14 for List range.
Enter $A$1:$A$2 for Criteria range.
Leave Unique records only unchecked.
Activate OK.

Use the visible range as source for the bar chart.

Aladin

PS. Hope someone will offer a more effective approach.




[ This Message was edited by: Aladin Akyurek on 2002-05-15 07:32 ]

[ This Message was edited by: Aladin Akyurek on 2002-05-15 07:33 ]

[eliW]

On 2002-05-15 07:14, Casey wrote:
Actually that didnt work, I was just using the "unique records only" selection, and it turns out that I have quite a few repeats , so I cant do that.
Idont know if there is something simialr or if that was what I was supposed to do.
Thanks
Casey

Hello Casey ,
I am following Aladin's second suggestion, but instead of doing Adv Filter, Just Autofilter your column on NonBlanks and your BarChart will be OK
Eli

[Casey]

Thanks The autofilter works great. thanks to all of you for your help
Casey