Chart Help

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...
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

saurabh726

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

Active Member
Joined
Sep 10, 2003
Messages
276
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,122,822
Messages
5,598,304
Members
414,224
Latest member
Crazy_FC

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top