How to Change Markers on Excel Graph

In this Excel tutorial, you will learn one easy trick. You will learn how to change the color of the markers on your chart. You may need this to customize your chart.

Preparing to change data points

In Microsoft Excel, markers are symbols used to identify individual data points on a graph. To change the markers on a graph in Excel, follow these steps:

1. Consider the data set with a chart window.

example chart

2. Right-click on the marker to bring up a dropdown menu. Then select the Format Data Series option.

format markers

3. A window will appear like this below.

format data series

Changing markers color

4. From the left side, select Marker Fill and then Solid Fill from the color palette. Select the new color of the marker.

solid fill markers

You can choose from a variety of marker shapes, such as squares, diamonds, or circles.

If desired, you can format the markers by right-clicking on the markers and choosing “Format Data Point” from the context menu. In the “Format Data Point” dialog box, you can adjust the size, color, and border of the markers.

5. Now here you go with the new color of your marker.

markers changed color

Using Formulas

You can use Excel formulas to determine the color of each marker based on the underlying data. For example, you can set up a formula that evaluates whether a data point meets certain criteria and assigns a color accordingly. This approach provides dynamic coloring that updates as your data changes.

See also  How to Make Surface Chart

=IF(A2>10, “Green”, IF(A2>5, “Yellow”, “Red”))

This formula checks the value in cell A2 and assigns marker colors (Green, Yellow, or Red) based on the value.

Using VBA Code

Write VBA code that loops through data points in your chart and assigns custom marker colors based on your criteria. This approach allows for intricate marker customization and dynamic updates as data changes.

Sub CustomizeMarkers()
    Dim cht As ChartObject
    Dim srs As Series
    Dim i As Integer

    Set cht = ActiveSheet.ChartObjects("Chart 1")

    For Each srs In cht.Chart.SeriesCollection
        For i = 1 To srs.Points.Count
            If srs.Points(i).YValues(1) > 10 Then
                srs.Points(i).MarkerBackgroundColor = RGB(0, 255, 0)
                srs.Points(i).MarkerBackgroundColor = RGB(255, 0, 0)
            End If
        Next i
    Next srs
End Sub

This VBA code customizes marker colors based on specific conditions. You can adapt the code to your requirements.

By following these steps, you can change the markers on a graph in Excel and customize the appearance of your graph to better suit your needs.