I'm new to charting and named ranges, so I'm struggling with it and think there's probably an easy solution. I have attached the workbook with a pie chart that has some example labels and data. If the value of the data is zero, I don't want it included in the chart. I have named ranges that I'm having a problem referencing. I think it will work once I resolve that... There will be macros eventually, so it needs to stay an xlsm file (if that matters). Thanks for any help/suggestions.
Bookmarks