Forum Discussion

György Popovics's avatar
György Popovics
Copper Contributor
Nov 07, 2017

How to change the default settings of the markers in graphs?

Hi!
I need some help in excel 2016!
I'd like to make graphs, in a way that each of them have lot of lines and points on it.
I'd like to change the markers, but it's too much time to do it on by one line.
Is there any way to change the default setting of the markers?
From circle to cross and the size? The question above is still relevant for the trendlines on points.
Thank you for your help! :)
Excel 2016
Graphs
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Nov 08, 2017

    Hi,

     

    Actually, you can't change all markers of lines at once, unless you use some lines of code written in Excel scripting language (VBA)!

    And you can't change the default style and size of these markers!

     

    It would be a good idea if you asked Microsoft about this functionality to provide it in Excel on this link: Excel User Voice

     

    However, I have already a code that will solve your problem!

    Do you want to use the VBA?

Resources