Forum Discussion
Line graph with dots/markers and no line
Hi SoniaL,
To change marker and line style, please drag a column to “legend” and switch to format->legend->style like below:
Best Regards,
Jimmy Tao
Removing the Line
Go to Chart Format options >> Shapes, then set Stroke Width to 0 (Zero)
Solution SageAnonymous
I Believe, you are using Line and Stacked Column Chart.
1. Go to Chart Format options, Go to Data color then Select the Color to white (Hiding the line)
2. Now, just below , there is a section called Shapes, Just Select Show Marker. That's it.
Hi rocky09,
I can't see a 'show marker' option under shapes...
Also, in some cases, the line goes over the columns, so you can see the white ... there's no way to turn the line off completely?
Thanks again,
Sonia
Ignore that, i released my x axis had to be on 'categorical'!
Ideally i can change the line to transperant, but I'm not sure there's an option for that...
Thanks for your help!
v-yuta-msftCommunity Support
Hi SoniaL,
To change marker and line style, please drag a column to “legend” and switch to format->legend->style like below:
Best Regards,
Jimmy Tao
Morten_DKHelper I
I don't seem to have that option to show only markers. I am on March 2018 version - shouldn't it work there also?