Chart to Ignore 0 Values

What is the chart type? Bar? line?

My first recommendation for something like this is to use the built in autofilter (http://www.wikihow.com/Use-AutoFilter-in-MS-Excel ). You can instruct the filter to hide those 0 values, and the chart should follow. Is your spreadsheet arranged in a way that an autofilter could easily be applied to it?

Then my next suggestion is to look at this essay (http://peltiertech.com/mind-the-gap-...g-empty-cells/ ) because I expect that the principles in that essay are going to be important to the solution. I also expect that the ideas behind "dynamic named ranges" and how they are used to build dynamic charts (http://peltiertech.com/dynamic-charts/ ) will also be important.

Beyond that, I'm not sure how much we can help without knowing how your data are arranged in the spreadsheet.

Originally Posted by MrShorty

...Beyond that, I'm not sure how much we can help without knowing how your data are arranged in the spreadsheet.

Or without beating about the bush:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.