Forum Discussion
Solved
How can I stop Excel from changing the colors of my chart ?
I have a chart with past and forecasted figures for several series of data. I set the colors of each serie in order to have something nice and meaningful : 1 color per serie, dotted for forecast. E...
File > Options > Advanced > Chart >
deselect 'Properties follow chart data point for current workbook'
deselect 'Properties follow chart data point for all new workbooks'
I have similar issue, when i prepared the pivot pie and bar chart out of pivot table, after refresh the format of charts are changing, the grand total is occupying its place in charts, which is not looks good in the report, even i made many changes to it, after refresh it regains back.
Then i went for a solution, opened power bi, opened excel there and imported datainto it and downloaded the excel to my local, then i made my changes, that worked.
Then i went for a solution, opened power bi, opened excel there and imported datainto it and downloaded the excel to my local, then i made my changes, that worked.