Remove legend if value is N/A

**defy** · 01-01-2011, 02:03 AM

Hi all!
Here to scoop up some of your help again =) =P

I have a bar chart and a lot of it is blank because a lot of the values i have are n/a (so zero wont show) is there a way to prevent the cart d\from displaying data if it is n/a or 0? maybe a macro of some sort?

Smar question on MR.Excel

Cheers yall!

**DonkeyOte** · 01-01-2011, 05:58 AM

Your post does not comply with Rule 8 of our Forum RULES.
Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.
We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
We are here to help so help us help you!

Read this to understand why we ask you to do this

**defy** · 01-01-2011, 02:45 PM

Mah apologize, good Sir. I shall eradicate this error with out most haste! Did not realize the forums where linked =)

http://www.mrexcel.com/forum/showthr...24#post2559524

**protonLeah** · 01-01-2011, 03:43 PM

You need to post your sample workbook so that members don' t have to guess what you mean or make up one from scratch.

**defy** · 01-04-2011, 07:39 PM

Originally Posted by protonLeah

You need to post your sample workbook so that members don' t have to guess what you mean or make up one from scratch.

I would like to minimize the size or remove it completely as there is no data in these highlighted red areas.

Rows cannot be hidden as data will be there eventually.