I have created a Pivot Chart with a secondary axis the way I want it. When I refresh (including adding or changing) the data in the associated table, I have a problem with the secondary axis dropping as well as the chart losing all the design. I think the issue with the table losing the axis was related to having filtered data during the refresh, so I believe I have resolved that problem. The chart however is still losing my design. I have save the chart as a template and I'm still having the same issue. Any suggestions?
Solved by I. B. in 18 mins