How to replace columns with 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, see the image below. I am going to use this picture in my chart. It is not as nice as the other chart but it will do for this demonstration.
Table of Contents
1. Create a column chart
- Select the data, see image above.
- Go to tab "Insert" on the ribbon.
- Select a new clustered column chart.
2. Delete the chart legend
- Press with left mouse button on the chart legend to select it.
- Press Delete on your keyboard to remove it from the chart.
3. Change chart gap width
- Press with right mouse button on on the data series.
- Press with left mouse button on "Format Data Series...". You will now see a dialog box or a settings pane depending on what Excel version you are using.
- Press with left mouse button on Series Options.
- Change gap width to 20%.
- Close the dialog box.
4. Insert a picture to chart column
- Press with left mouse button on "Fill and Line"
- Press with left mouse button on "Picture or texture fill".
- Press with left mouse button on the "Insert.." button.
- A dialog box appears. Select a picture file you want to use.
- Press with left mouse button on Insert.
5. Change min y-axis value
- Press with right mouse button on on chart y-axis, see image above. A popup menu shows up.
- Press with left mouse button on "Format axis..."
- Press with left mouse button on "Axis Options".
- Change the minimum value to 0 (zero).
- Press with left mouse button on OK.
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
Charts category
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]
This article demonstrates macros that automatically changes the chart bar colors based on the corresponding cell, the first example is […]
Column chart category
This article demonstrates macros that automatically changes the chart bar colors based on the corresponding cell, the first example is […]
This interactive chart allows you to select a country by press with left mouse button oning on a spin button. […]
This tutorial shows you how to add a horizontal/vertical line to a chart. Excel allows you to combine two types […]
Excel categories
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.
