Forum

Notifications
Clear all

1. Presenting the Numbers

3 Posts
2 Users
0 Reactions
155 Views
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
Topic starter
 

Just love your infographic shark chart in the sample file.

That gave me a thought, is it possible to make a bar chart or an in-cell chart using pictures?
Else I need to learn more how to use picture editing tools. Smile

Br,
Anders Sehlstedt

 
Posted : 14/09/2017 3:43 pm
(@harold)
Posts: 10
Active Member
 

Hi Anders,

Yes, it's not too hard to make a bar chart using pictures.

First get a small picture that you want to use in the chart.  Here I have used one called fish.jpg [there's plenty of free clip art on the web], and attached an Excel workbook made with it.

When you have made a chart, click on the data series and use the Format Data Series in the Chart Tools.  

The important part here is to select 'Picture or texture fill and then point to the small picture file to insert.

2017-09-14_18-50-02.jpg

By experimenting with the attached, you'll see how you can get different effects by working with the Stretch, Stack and Stack/Scale buttons.

Hope this helps.  The final chart looks like this:

2017-09-14_18-57-27.jpg

Cheers
Harold

fish.jpg

 
Posted : 15/09/2017 5:00 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
Topic starter
 

Hi Harold,

I will be stuck with playing around with this later this evening. Thanks for the tip.

/Anders

 
Posted : 15/09/2017 6:38 am
Share: