Use pictures in a column chart
I found an interesting chart on CNN's website: Rise of the supersize rugby player It shows the average height of athletes for the past 40 years. Check it out.
It made me think how can I do this in excel? First I drew this nice man. I am going to use him in my chart. It is not as nice as the other chart but it will do.
I searched for average heights around the world and found some statistics: Wikipedia. I chose a few countries and built a small data table.
Select the table and go to tab "Insert" on the ribbon. Select a new clustered column chart.
Delete the legend then right click on the data series. Click "Format Data Series...". Click Series Options and change gap width to 20%.
Click Fill and "Picture or texture fill". Click "File..." button. Select a picture. Click Insert.
Change the y-axis minimum value, right click y-axis. Click "Format axis..." and change minimum value to 0 (zero). Click OK.
Download excel *.xlsx file
Pictures-in-a-column-chart.xlsx
Read more
- Build a comparison chart
- Add pictures to a chart axis
- An animated bar chart
- Highlight a bar in a chart
- Heat map using pictures
- Use a map in an excel chart
Related articles
Format fill color on a column chart based on cell color
Table of contents Format fill color on a column chart based on cell color Change stacked bar colors Mark Graveson [โฆ]
Highlight a column in a stacked column chart
This interactive chart allows you to select a country by clicking on a spin button. The chart and table shows [โฆ]
How to add horizontal line to chart
This tutorial shows you how to add a horizontal/vertical line to a chart. Excel allows you to combine two types of [โฆ]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: [โฆ]
How to use mouse hover on a worksheet [VBA]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option [โฆ]
Change chart data range using a Drop Down List [VBA]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above [โฆ]
How to create an interactive Excel chart [VBA]
This article describes how to create an interactive chart, the user may click on a button or multiple buttons and [โฆ]
Format fill color on a column chart based on cell color
Table of contents Format fill color on a column chart based on cell color Change stacked bar colors Mark Graveson [โฆ]
Highlight a column in a stacked column chart
This interactive chart allows you to select a country by clicking on a spin button. The chart and table shows [โฆ]
The drop down list lets you select a region. An event macro checks if there is a new drop down [โฆ]
How to add horizontal line to chart
This tutorial shows you how to add a horizontal/vertical line to a chart. Excel allows you to combine two types of [โฆ]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
English
Spanish
