how to place jpeg image at end of each horizontal bar graph bar

palaeontology

Active Member
Joined
May 12, 2017
Messages
444
Office Version
  1. 2016
Platform
  1. Windows
Is it possible to automatically have a jpeg (or other) image placed at the end of each horizontal bar in a horizontal bar graph, similar to the image below ...

horse race.JPG


I'm guessing we would have to dictate the size dimensions the image would need to keep to so it doesn't dominate the graph itself.

If the above idea is at all possible, is it feasible to take it a step further, where the icon that is placed at the end of a bar is determined by the value of the bar, for example ..

* if the bar value is below 5, it would display image A
* if the bar value is between 5 and less than 10, it would display image B
* if the bar value is between 10 and less than 15, it would display image C
* if the bar value is between 15 and less than 20, it would display image D
* if the bar value is between 20 and less than 25, it would display image E
ETC

I dabbled in this years ago, but got nowhere.

Does anyone have any thoughts ?

Kind regards,

Chris
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Is it possible to automatically have a jpeg (or other) image placed at the end of each horizontal bar in a horizontal bar graph, similar to the image below ...

View attachment 10042

I'm guessing we would have to dictate the size dimensions the image would need to keep to so it doesn't dominate the graph itself.

If the above idea is at all possible, is it feasible to take it a step further, where the icon that is placed at the end of a bar is determined by the value of the bar, for example ..

* if the bar value is below 5, it would display image A
* if the bar value is between 5 and less than 10, it would display image B
* if the bar value is between 10 and less than 15, it would display image C
* if the bar value is between 15 and less than 20, it would display image D
* if the bar value is between 20 and less than 25, it would display image E
ETC

I dabbled in this years ago, but got nowhere.

Does anyone have any thoughts ?

Kind regards,

Chris
Hi,
If I understood you well, what you can do is below:
  1. Download the horse icon
  2. Go to your chart and choose "Format Data Labels"
1585502015181.png


3. then after you choose Picture or texture fill, you'll get options below, choose file

1585502103420.png


then go to where you saved the horse icon, and choose it and this is what you'll get:

1585502151912.png


Hope this answered your question.
 
Upvote 0
That worked brilliantly, thankyou for taking the time to respond to my query.

Very kind regards,

Chris
 
Upvote 0

Forum statistics

Threads
1,215,425
Messages
6,124,824
Members
449,190
Latest member
rscraig11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top