Is it possible to create "infographic" like this in Excel?

[kubazabran]

Hello, we have lot of data in Excel and we create simple charts from that. I'm wondering if it is possible to create something like this in Excel - connect the chart and table. I know I can add values to data labels but it doesn't look very good.

Anybody knows? Or I will need to use some different tool? Thanks

 

[Dan_W]

Like this?

 

[kubazabran]

Like this?
View attachment 98267

Yeah, something like that. May I ask how you've made that? Thanks

 

[Dan_W]

In Excel. I used a trick which uses formulas to draw what looks like a horizontal bar using the Playbill font and the | character. You can see the settings and the formula in the screen capture.

 

[Dan_W]

The data is dynamically sourced from a Data sheet using Names:

I called the units column "Company" for some reason - apologies.

 

[Dan_W]

The coloured YoY and MoM are autoformatted using custom number formatting (as opposed to conditional formatting):

[Color50]+##0%;[Red]-##0%;"/"

 

[Dan_W]

You could make it look nicer with more time (and a better sense of design than me), but I just knocked that up quickly. Hope that helps.

 

[kubazabran]

creative solution perfect, thanks, I'll try to do replicate that later

 

[Dan_W]

Sorry, have been wrestling with the browser to try and upload the demo XSLSX file in case you wanted to test it out. Here is a download link in case you or anyone else wanted to try it: Sample InfoGraphic

 

[kubazabran]

Hi Dan, thanks a lot, I made it work for our case. Just one note, maybe for others - the color code didn't work for me as "Color" but as "Colour" - I have EN excel on macos.

So if anyone has issues, try [Colour50] instead of [Color50]