Customizing Markers in a Chart

An icon of a car feels so cool when you are talking about cars in a chart. Isn’t so? Let’s see how can we do that!

 

Assume this data

Customizing Markers in a Chart 2

And we make a line chart (with markers) out of it.

Customizing Markers in a Chart 3

Notice the dots on the line chart

  1. Those dots are called markers and we are going to customize them
  2. So make sure that when you are picking up the line chart you choose Line with Markers

 

Lets get a Car Icon

You can easily find vector icons on the web. Assuming that we have got a car icon in our spreadsheet, let’s plug that into our chart

Customizing Markers in a Chart 4

Here are the steps

  1. First copy the car icon using Ctrl + C
  2. Then select the markers in the line chart and paste the icon using Ctrl + V
  3. You’ll see that the (markers) dots are now replaced by the car icon

A few things that you must care about 

  1. The size of icon selected is exactly replicated in the chart, so make sure to size the icon appropriately to fit in your chart
  2. Customizing markers is cool but not always appreciated by good old folks, who still are comfortable with the traditional lines and bar charts. So use it with caution!

DOWNLOAD THE CHART HERE

 

More Interesting Charts for You

  1. How to Highlight Parts of a Stacked Chart – to make it more readable
  2. Encircle Points in a Line Chart
  3. Adding Direct Legends to the Chart – to make it clutter free
  4. Draw a Chart in 1 Key Stroke
  5. Adding a Total Bubble at the end of the Line Chart
  6. How to Plot Cities on a Map Chart – One of the coolest charts I have ever made!

 

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI