How to create a "half doughnut" chart

Question

Hi,

I Need to create a Report where I Show a Chart where only half a doughnut is displayed... So the half doughnut is 100%... Probably you know this visualization from elections when the share of seats is displayed... It's not for that use case but it should look similar.

Any idea how to do that?

Thanks,

---

Thomas Pagel

Answer 1

Something of this sort? What version of SQL Server are you using this is possible in 2008 on

You can create a doughnut chart and also check the custom attribute properties, follow below link

http://technet.microsoft.com/en-us/library/dd220514.aspx

Regards,Eshwar.

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

Answer 2

Hi,

so this is a typical dougnut Chart, I know how to build it. However what I Need is something like you would eat half of the dougnut (so you really do only see half of it) but still Show the percentage in the remaining part. So taking your sample Accessories are around 60%, Bikes 25% and Clothing 15%. It should look like a hidden 50%, Accessories 30%, Bikes 12.5% and Clothing 7.5%. If the percentages are displayed then I still should see the 60/25/15% so just adding that invisible 50% wouldn't help...

Thanks,

---

Thomas Pagel

Answer 3

Hi Thomas,

From your description, you want to design a semicircular Doughnut chart which displays the right values as the common Doughnut chart. If so, I am afraid this cannot be done in SSRS currently.

I would suggest you submitting a wish at https://connect.microsoft.com/sql.

Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

Regards,
Mike Yin

If you have any feedback on our support, please click here

---

Mike Yin
TechNet Community Support

Answer 4

Hi Tom,

This is a hack, but you could make the segments that you want to obscure, Fill="White" on a white background.  I tried this and it works for me, but it might not be the exact effect you want. 

Give it a try.

---

DJAnsc