Forum Discussion

fabien.calendar's avatar
fabien.calendar
Copper Contributor
Jun 21, 2017
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...
Charts & Visualizing Data
Need Help
  • mbiscotto's avatar
    mbiscotto
    Feb 12, 2019

    File > Options > Advanced > Chart >

    deselect 'Properties follow chart data point for current workbook'

    deselect 'Properties follow chart data point for all new workbooks'

mbiscotto's avatar
mbiscotto
Brass Contributor
Feb 12, 2019

File > Options > Advanced > Chart >

deselect 'Properties follow chart data point for current workbook'

deselect 'Properties follow chart data point for all new workbooks'

  • jacky-ms's avatar
    jacky-ms
    Copper Contributor
    Feb 28, 2024

    mbiscotto  Thank you!  It's my life saver of the month.

  • DrGrave's avatar
    DrGrave
    Copper Contributor
    Jan 28, 2024

    mbiscotto You're a saviour! Been thinking about that one for ages, many thanks 🙂

  • babrock's avatar
    babrock
    Copper Contributor
    Aug 31, 2022
    Awesome suggestion!
  • Davidxing1007's avatar
    Davidxing1007
    Copper Contributor
    Jun 22, 2022
    Thank you so much!! It was driving me crazy haha
  • MNMullinix's avatar
    MNMullinix
    Copper Contributor
    Jun 12, 2022
    This used to work, but Microsoft fixed in recent versions so that it doesn't.
  • pieterkd's avatar
    pieterkd
    Copper Contributor
    Feb 12, 2022
    Thank you my friend !!!
  • Pankaj2711's avatar
    Pankaj2711
    Copper Contributor
    Sep 18, 2021
    Thanks a lot
  • Marjolein71's avatar
    Marjolein71
    Copper Contributor
    May 17, 2021
    mbiscotto, thanks for your answer. You're my hero! 🙂
    For already a year or so I am getting angry at my current Excel version for changing the perfected layout of my data series every time I copy a graph and adjust the actual input for the data series. Thanks!
  • Kimmy101's avatar
    Kimmy101
    Copper Contributor
    Mar 12, 2021

    mbiscotto 

    Doesn't work in Excel Pro Plus 2016.  Using a slicer to filter reassigns the line colors to the remaining items.  Both of those advanced boxes defaulted to being checked... I deselected, saved, closed Excel, reopened.  This is a very, very simple chart - 2 locations over time, line chart, colors assigned.  Slicer filter to either location, they both use only one of the two colors.  Thanks!

Resources