I have a table that when I use the slicers to select other the data the secondary axis for a specific data disappears. In the attached file the purple colored data is supposed to be on the secondary data. See slicer output tab.
I have a table that when I use the slicers to select other the data the secondary axis for a specific data disappears. In the attached file the purple colored data is supposed to be on the secondary data. See slicer output tab.
seems like its a known issue since very long time ago...before slicers and still remains a problem
found this from 2005
http://www.excelforum.com/excel-char...ble-chart.html
instead of VBA which is not for everybody
see below link on how this issue can be tackled
http://peltiertech.com/pivot-chart-formatting-changes/
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks