Author Topic: Elegant way to recreate this amazing infographic using shapesheet?  (Read 582 times)

0 Members and 1 Guest are viewing this topic.

Visisthebest

  • Hero Member
  • *****
  • Posts: 626
The university of Oxford has published the attached attractive circular data chart, see also:
https://ourworldindata.org/emissions-by-sector

I have seen several impressive examples of circle-based graphics in Visio but not exactly like this pie chart with some text curved on the circle (in two different ways) and some text unrotated on the main pie elements.

There are actually three circles here.

What would be an elegant way to create such a graphic in Visio using the shapesheet’s power for adding and deleting data on the circle(s) and the graphics updating when the changes are made.

It would be an impressive demonstration of Visio’s visual potential on a key subject (climate change).

Thank you for sharing your ideas!

« Last Edit: May 11, 2022, 05:07:45 AM by Visisthebest »
Visio 2021 Professional

Surrogate

  • Hero Member
  • *****
  • Posts: 1534
    • ShapeSheet™ Knowledge Base
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #1 on: May 11, 2022, 05:42:02 AM »
IMHO We haven't build-in tools for create same infographics in Visio ! Sorry…
May be best way use PowerBI or/and Excel ?

Visisthebest

  • Hero Member
  • *****
  • Posts: 626
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #2 on: May 11, 2022, 05:54:07 AM »
I am sure this infographic can be made in Visio, certainly with a bit of code but most likely also with a set of shapesheet formulas.

If PowerBI supports this graphic that is easier for sure, but I would like to build this as a well-designed and configurable Visio group shape!

Visio 2021 Professional

Yacine

  • Hero Member
  • *****
  • Posts: 2923
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #3 on: May 11, 2022, 07:12:51 AM »
What about this 12 years old post? ;)
http://visguy.com/vgforum/index.php?topic=1598.msg6797#msg6797


Yes, one is a radar graph, the other a pie chart, but the techniques are quite similar.


From memory, the most valuable technique was the self-incrementing sub-shape - a technique lent from Chris, if I remember well.
The idea is that you have smartshapes inside a bigger one.
You set it up to your needs and make sure that the formulas involved use the prop.num for this one specific need (position, color, text, whatever).
When duplicating the sub-shape inside the parent, the drop-event will increase automatically your counter (prop.num), thus the sub-shapes know what to do.
I've used and re-used this technique so many times. Proven, safe, useful!


« Last Edit: May 11, 2022, 07:39:59 AM by Yacine »
Yacine

Visisthebest

  • Hero Member
  • *****
  • Posts: 626
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #4 on: May 11, 2022, 07:22:32 AM »
Thank you Yacine impressive radar graph, certainly this helps to build parts of the specific CO2eq emissions graph!
Visio 2021 Professional

Yacine

  • Hero Member
  • *****
  • Posts: 2923
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #5 on: May 11, 2022, 07:48:32 AM »
Looking forward to appreciate your work. ;)
Yacine

Surrogate

  • Hero Member
  • *****
  • Posts: 1534
    • ShapeSheet™ Knowledge Base
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #6 on: May 11, 2022, 08:45:36 AM »
the other a pie chart
Exactly, you can modify the "Pie chart" shape ! This shape contains colorful 10 sectors.

vojo

  • Hero Member
  • *****
  • Posts: 1657
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #7 on: May 11, 2022, 08:49:29 AM »
Let me know if you need something like these
no VBA / All shapesheet

vojo

  • Hero Member
  • *****
  • Posts: 1657
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #8 on: May 11, 2022, 08:50:10 AM »
or these

vojo

  • Hero Member
  • *****
  • Posts: 1657
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #9 on: May 11, 2022, 08:51:52 AM »
or these

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4331
  • Ideas Visio-lized into solutions
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #10 on: May 11, 2022, 09:31:04 AM »
The chart shouldn't be that difficult. I can "Visiolize" using multiple, stacked shapes...largest diameter on the bottom and progressively smaller diameters moving toward the top.  Some would have no fill...the outer text, some would be pie charts, some just solid white circle, e.g., to create the inner white band.  One way for the outer text would be a quasi-pie shape.  That is, large circle that has been fragmented such that the text would have varying amounts of rotation...I don't think "gravity" would work. 

As Vojo says, all done in shapesheet.

Because of the various fill, font colors, etc, it would take multiple shapes, but, they could be grouped.  The sector sizes, text, etc could be in an Excel file or other data base, to allow a more flexible design...creating a mega smart shape structure as Yacine indicates.
« Last Edit: May 11, 2022, 09:32:47 AM by wapperdude »
Visio 2019 Pro

Visisthebest

  • Hero Member
  • *****
  • Posts: 626
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #11 on: May 12, 2022, 01:46:51 AM »
Thank you all I think I'll be able to figure something out, I might create a solution that uses a bit of VBA as well and then replace it with a shapesheet-only solution later. (I am a lot more comfortable with code, but getting more comfortable with the shapesheet)

When I have something that works well and looks as good as the original pie chart, I will share it here.
« Last Edit: May 12, 2022, 05:26:45 AM by Visisthebest »
Visio 2021 Professional

Yacine

  • Hero Member
  • *****
  • Posts: 2923
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #12 on: May 12, 2022, 02:48:57 PM »
Thank you Visisthebest for this challenge. A very nice one.

My ideas on it:
- Not a complete mega-smartshape, but the donut segment definitely as one.
- All properties controlled by custom data, so you can generate them by linked excel file. There are so many that you shouldn't go for a manual version.
- The segment consists of
 - the standard donut segment but tailored to our needs.
 - a circular text shape, which splits the text of prop.Text1 into individual shapes and shows them on a circle.
   a lot of work left to you on this point - distances between the letters, start and stop angle, etc.
 - the donut shape got also a prop.TextOrientation so you can chose manually (or via excel) how to display your text. I thought of circular/horizontal/gravity. The 2 other options are left to implement by yourself.
 - a Text2 prop is foreseen so you can put 2 lines of text. --> open
 - The segments are arranged by putting their PinX and PinY to the same value. Could be added to the props.
 - The placement requires a cummulative column in excel for the starting angle. The shapes don't know anything about each other.
 - The values and start-values are meant as percent of the circle.
 - The out-radius is set in prop.Radius, the inner one in the other according prop.

That's it. I had a lot of fun.
Yacine

Visisthebest

  • Hero Member
  • *****
  • Posts: 626
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #13 on: May 13, 2022, 03:25:17 AM »
Thank you very much Yacine that is the foundation I'm looking for!

To put the underlying chart data (text and values) in Excel is the best option for sure, wouldn't want to use the shapesheet UI to enter this info.

Visio 2021 Professional

Visisthebest

  • Hero Member
  • *****
  • Posts: 626
Re: Elegant way to recreate this amazing infographic using shapesheet?
« Reply #14 on: May 13, 2022, 03:29:46 AM »
You also see some clever custom things in the original, like Grassland 0.1 with a line pointing to the small sliver of the pie. Impressive how this pie chart shows so much information in one picture.
Visio 2021 Professional