Chart Help

[saurabh726]

Hw do i make chart cells automatically selecting the non-blanks data and ignore the blanks data for ex...my chart source is..

=Sheet2!$B$5:$F$23....

Now this is been link filter and when i apply filter in it ...it creates some blank cells in my source of chart which gives me chart to look aukward...so i want to do is that if i apply filter to it and only 6 rows that i have data then my chart source should become automatically...

=Sheet2!$B$5:$F$11....

Is it possible to do that...??

Saurabh...

 

[saurabh726]

Looking for Solution

Anyone got a solution for this......???

Saurabh...

 

[saurabh726]

can i do nething for it to select cells automatically for graph which has the data only and change the source accordingly and automatically....

Saurabh...

 

[jdee]

If you are applying a filter to eliminate zero's, ie, greater than zero, then your chart should not plot the cells with zeros. Is this what you are doing/meaning? I just tried data showing cells with zeros, filtered for greater than zero, and the chart only shows the data with data in it (less the zero data).