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

kubazabran

New Member
Joined
Feb 22, 2022
Messages
13
Office Version
  1. 365
Platform
  1. MacOS
  2. Web
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

20230903_232320.jpg
 
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]
Do you mean you have en-GB? That's surprising that it wouldn't accept Color, but glad you got it working. Thank you for the feedback.
 
Upvote 0

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,215,093
Messages
6,123,069
Members
449,090
Latest member
fragment

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