Forum Discussion

Sekoleyte's avatar
Sekoleyte
Iron Contributor
May 07, 2022
Solved

Formatting Data Entry, Series Color Automatic Change Problem

Hi there. I created a file to show monthly amount distribution. I used 3 colors which are blue for planned, green for actual and red for forecast. I only want to use these 3 colors in my chart to sh...
excel
office 365
  • Sekoleyte's avatar
    Sekoleyte
    May 07, 2022

    I found it guys. There was a same topic here earlier 🙂
    I won't delete this one as hoping it helps others too. The solution is:


    File > Options > Advanced > Chart >
    deselect 'Properties follow chart data point for current workbook'
    deselect 'Properties follow chart data point for all new workbooks'

    In any case, thanks guys. I love you ! Continue to share your info and experiences !

Sekoleyte's avatar
Sekoleyte
Iron Contributor
May 07, 2022

I found it guys. There was a same topic here earlier 🙂
I won't delete this one as hoping it helps others too. The solution is:


File > Options > Advanced > Chart >
deselect 'Properties follow chart data point for current workbook'
deselect 'Properties follow chart data point for all new workbooks'

In any case, thanks guys. I love you ! Continue to share your info and experiences !

Resources