spot_img

How To Change The Color Of Markers On A Chart in Excel

In this Excel tutorial you will teach yourself one easy trick. You will learn how to change the color of markers on your chart. You may need this to customize your chart.1. Consider the data set with a chart window.example chart2. Select the marker upon right click a dropdown appear. Then select the Format Data Series option.

format markers

3. A window will appear like this below.

format data series

4. Select the Marker Fill option from left side and choose Solid Fill and from the colors. Select the new color of the marker.

solid fill

5. Now here you go with changed color of your marker.

markers changed color

Remember that the chart should be first of all easy to read for people who will use it. Color of marker should be distinct from the color of the line. Excel offers you whole range of colors to set. You can choose whatever colors you want.

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell