Secondary Axis Disappears Upon Refresh

%3CLINGO-SUB%20id%3D%22lingo-sub-234758%22%20slang%3D%22en-US%22%3ESecondary%20Axis%20Disappears%20Upon%20Refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-234758%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20Pivot%20Chart%20with%20a%20secondary%20axis%20the%20way%20I%20want%20it.%26nbsp%3B%20When%20I%20refresh%20(including%20adding%20or%20changing)%20the%20data%20in%20the%20associated%20table%2C%20I%20have%20a%20problem%20with%20the%20secondary%20axis%20dropping%20as%20well%20as%20the%20chart%20losing%20all%20the%20design.%26nbsp%3B%20I%20think%20the%20issue%20with%20the%20table%20losing%20the%20axis%20was%20related%20to%20having%20filtered%20data%20during%20the%20refresh%2C%20so%20I%20believe%20I%20have%20resolved%20that%20problem.%26nbsp%3B%20The%20chart%20however%20is%20still%20losing%20my%20design.%26nbsp%3B%20I%20have%20save%20the%20chart%20as%20a%20template%20and%20I'm%20still%20having%20the%20same%20issue.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-234758%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi,

 

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?

0 Replies