Forum Discussion

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
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

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'

tharangaj

Copper Contributor

Sep 29, 2020

mbiscotto I am looking to find this on excel 365 on mac, any ideas where it is? I checked preferences charts but couldn't find the option

mbiscotto
Brass Contributor
Sep 30, 2020
tharangaj not a Mac user (or know one), so can't help. feel free to write back after you've switched to PC/Win10...
- tharangaj
  Copper Contributor
  Sep 30, 2020
  mbiscotto used the VBA script below and it worked. actually switched from PC recently.
  
  Application.ChartDataPointTrack = False
  ActiveWorkbook.ChartDataPointTrack = False
  - OrgilP
    Copper Contributor
    Mar 04, 2023
    tharangaj
    Very nice thanks.
    I have adjusted to my preferences as:
    Make workbook xlsm
    Under Thisworkbook
    Private Sub Workbook_Open()
    ThisWorkbook.ChartDataPointTrack = False
    End Sub
    By doing this, even if other people open this chart won't go crazy as well 🙂