How to Change Marker Shape in Excel Graph (3 Easy Methods)

Excel automatically creates a shape for the marker when creating a Line, (XY) Scatter, and Radar chart. These data markers help to visualize the value of the data point clearly. However, in many situations, we need to change marker shapes so that they become more visible and eye-catching.

The following dataset has Month and Monthly Profit columns.

How to Change Marker Shape in Excel Graph

Using this dataset we will insert a Line with Markers chart, then change the marker shapes. We used Excel 365 here, but you can use any available Excel version.

To insert a Line with Markers chart:

  • Select the entire dataset.
  • Go to the Insert tab.
  • From Insert Line or Area Chart group, select the Line with Markers chart.

A Line with Markers chart is generated, with clearly visible marker points on it.

How to Change Marker Shape in Excel Graph


Method 1 – Using Format Data Series Feature

STEPS:

  • Click on any marker of the graph, which will automatically select all the markers of the graph.
  • Right-click on it.
  • Select Format Data Series from the Context Menu.

A Format Data Series dialog box will appear at the right end of the Excel sheet.

  • Select the Fill & Line option >> select Marker >> select Marker Options.
  • From Marker Options >> select Built-in box.
  • Click on the downward arrow of the Type box.

How to Change Marker Shape in Excel Graph

Several marker shapes appear. Select any of them according to your preference.

  • Select a rectangle as a marker shape.

In the Type box, a rectangular shape appears.

  • Set the Size to 15 (you can select any Size of your choice).

How to Change Marker Shape in Excel Graph

  • Click on the drop-down arrow of the Color box.
  • Select Orange, with Accent 2 as our marker color.

The graph now has rectangular marker shapes.

How to Change Marker Shape in Excel Graph

Read More: How to Add Data Markers in Excel 


Method 2 – Using Format Selection Option

STEPS:

  • Click on any marker of the graph, which will automatically select all the markers of the graph.
  • Go to the Format tab >> click on Current Selection.

  • From the Current Selection group, select the Format Selection option.

How to Change Marker Shape in Excel Graph

A Format Data Series dialog box appears at the right end of the Excel sheet.

  • Select the Fill & Line option >> select Marker >> select Marker Options.
  • From Marker Options >> select Built-in box.
  • Click on the downward arrow of the Type box.

Several marker shapes appear. You can select any marker shape of your choice.

  • Select a triangle as a marker shape.

In the Type box, a triangular shape is shown.

  • Set the Size to 15 (or any Size of your choice).

How to Change Marker Shape in Excel Graph

  • Click on the drop-down arrow of the Color box.
  • Select Green, Accent 6 as our marker color.

The graph now has triangular marker shapes.

Read More: How to Add Markers for Each Month in Excel 


Method 3 – Using a Custom Marker

You can change the marker shape in an Excel graph by inserting custom pictures or shapes for individual marker points.

How to Change Marker Shape in Excel Graph

STEPS:

  • Create a Shape column in our dataset.

  • Go to the Insert tab >> click on Shapes.

A huge number of shapes is displayed.

  • Select the Star shape.

  • Insert the Star shape in cell D5 for January month.

How to Change Marker Shape in Excel Graph

Now we insert this shape in the graph.

  • Select the Star shape and right-click on it.
  • Select the Copy option from the Context Menu.

  • On our chart, double click on the January marker (a double-click will select one single marker point).
  • Press CTRL+V to paste the copied Star shape on the marker.

How to Change Marker Shape in Excel Graph

The marker for January month now has a Star shape.

  • Repeat the same process to insert different shapes for every individual month in the Shape column.
  • Copy the shapes and paste them onto the markers of the graph.

The markers on the graph now have different shapes.

How to Change Marker Shape in Excel Graph

Read More: How to Make Legend Markers Bigger in Excel 


Download Practice Workbook


<< Go Back To Markers in Excel | Excel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of NAME from Bangladesh University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also interested... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo