saurabh726
Well-known Member
- Joined
- Dec 13, 2003
- Messages
- 891
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...
=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...