Chart - hide zero??

[kizzie37]

Hi

Is it possbile in Excel 2010 (or earlier) to have a chart show only those items that have a value greater than zero, without having to manually exlude that data??.

 

[Joneye]

Hi

Is it possbile in Excel 2010 (or earlier) to have a chart show only those items that have a value greater than zero, without having to manually exlude that data??.

If you can post some data I can see what I can do, I use charts daily and link them to tables this works well for me.

 

[Smitty]

There are Hidden and Empty Cell settings that you can play with, but if you don't want 0's to plot you can use =NA(), as #N/A won't plot (it won't flatline your chart).

You can use it like this:

=IF(A1=0,NA(),A1)

HTH,

 

[kizzie37]

simplistic, but you should get the idea, suppose i have a bunch of cells with values, and then mixed in some at zero value, they would change each week

Book1
	A	B	C	D	E
1	JobDescription	JobClassification	TODATE1	TODATE2	TotalCost
2	TEST1	AAAA	$7,000.00	$11,000.00	$18,000.00
3	TEST2	BBBB	$16,000.00	$2,000.00	$18,000.00
4	TEST3	CCCC	$-	$-	$-
Sheet1