palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- 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 ...
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
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