How to hide 0s in graph using VBA?

[zaser]

I want to create a Line chart that doesn't graph 0 values. I know there are methods to change the data to be able to graph 0s but I can't do that for a variety of reasons.

Is there anyway of not graphing the zeros? Or replace all the 0 values in an array of arrays that represent my data?

I'd show you my code but I don't have anything related to this goal written because I'm not sure if Im missing something obvious or falsely assuming there is an easy way to do this.

 

[Joe4]

Duplicate re-posted here: https://www.mrexcel.com/forum/excel-questions/1106848-make-stop-graph-having-0-values-vba.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules). If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.