chart format changes when using slicer. When you apply a filter or slicer to a pivotchart the custom formatting can change with each change in the filter. When i filtered data using a slicer the formatting was erased, but only in some sections.
chart format changes when using slicer If yes, we'd like to explain that when you select an item in the slicer, the data. I have the chart color changed to what i want but when i select a slicer that may not have any records and back to one that has. When i filtered data using a slicer the formatting was erased, but only in some sections.
For Some Reason When I Create A Chart And Format It The Way I Want, When I Click On Another Agency Using The Slicer, The Chart.
I have 5 different slicer option, it changes my chart type(i had a. Keep the preserve cell formatting on update box checked. I have a combo chart that keeps changes the chart type from line chart to bar chart on the secondary axis.
If Yes, We'd Like To Explain That When You Select An Item In The Slicer, The Data.
When you apply a filter or slicer to a pivotchart the custom formatting can change with each change in the filter. When i filtered data using a slicer the formatting was erased, but only in some sections. The problem is that when you use the slicer in such a way that the information is not compatible with the chart, then the chart resets.
I Have The Chart Color Changed To What I Want But When I Select A Slicer That May Not Have Any Records And Back To One That Has.
After you create the slicer, click an item in the slicer?