Hello,
I am very new to PowerPivot and having difficulty determining if I am doing something wrong or if this happens to be a bug.
I am using Excel 2010 32 bit with the PowerPivot Add in Version: 11.0.3000.0.
One of the sheets in my workbook has 12 bar charts. All are connected to the same 3 slicers (Month, Day, Year).
Six of these charts show daily information while the other six shows the same information MTD. My trouble is with a pair of charts that can show both negative and positive percentages. The formatting of the data series changes when data is refreshed.
My fill settings are as follows:
Solid fill
Invert Negative
Color
Green and Red
Sometimes this changes to Automatic instead of Solid Fill and the Red color changes to white.
Any help would be greatly appreciated. Thank you for your time.
I am very new to PowerPivot and having difficulty determining if I am doing something wrong or if this happens to be a bug.
I am using Excel 2010 32 bit with the PowerPivot Add in Version: 11.0.3000.0.
One of the sheets in my workbook has 12 bar charts. All are connected to the same 3 slicers (Month, Day, Year).
Six of these charts show daily information while the other six shows the same information MTD. My trouble is with a pair of charts that can show both negative and positive percentages. The formatting of the data series changes when data is refreshed.
My fill settings are as follows:
Solid fill
Invert Negative
Color
Green and Red
Sometimes this changes to Automatic instead of Solid Fill and the Red color changes to white.
Any help would be greatly appreciated. Thank you for your time.