Forum Home
Press F1
Thread ID: 69010	2006-05-19 04:37:00	Excel chart	bpt2 (6653)	Press F1

Post ID	Timestamp	Content	User
455971	2006-05-19 04:37:00	I want to have a line chart that only shows the line when the data has a value other than "0". At the moment using Excel 2002 the range includes cells which will only get a value at a later date. Even if I use a formual such as "if(a2>0,a6+a8+a19,"") where a2 is blank, the chart line extends to zero and on to the end of the data range. I hope that makes sense.	bpt2 (6653)
455972	2006-05-19 04:57:00	The value needs to be empty. If there's any value, even text, it's going to show up as a data point. (I guess it's pretty obvious what datapoint TRUE would display as.) This won't work either: Tools... Options.... View tab... display Zero values check box. Maybe someone has a clever idea.	kingdragonfly (309)
1