In the attached image I have two graphs that are based on pivot tables from the same dataset, use the exact same pivot fields, and also are based on the exact same custom chart template. In one graph, if the series for the horizontal line is all zeroes, the line will not appear - this is what i want. In the other graph, when the values are zeroes the line appears at the bottom - this is what I don't want.
I have been through every single formatting option with the underlying pivot tables and graphs, but I still can't figure out what is different between them.
Can anyone explain what the differences could be between these two graphs?
I have been through every single formatting option with the underlying pivot tables and graphs, but I still can't figure out what is different between them.
Can anyone explain what the differences could be between these two graphs?
