Concentric circular graph

[Vignesh Veerasamy]

Hello Gurus,

Can know how to generate concentric circular graph as shown in attachment.
I have attached the sample data.
Each of variants will be updated for data against each months from April to Mar(Financial year cycle)
Searched the forum & was able to get single circular graphs with data.

Thanks in advance.



Vignesh.V

 

[Khalid NGO]

Hi Vignesh,

If you use Doughnut Chart you will be able to manage something similar to your requirement, I know this is not exactly what you were required, but see the example.

Regards,

 

[Vignesh Veerasamy]

Hi Vignesh,

If you use Doughnut Chart you will be able to manage something similar to your requirement, I know this is not exactly what you were required, but see the example.

Regards,

Dear Khalid,

Thanks for your response.
This seems good,but can the variant names be added? I tried the same but I am getting only like the attachment.

I want each of circles to be shown with Variant#1,Variant#2,Variant#3.
I tried path=>Design=>Add chart element=>Data labels=>Data call out,but I am not getting the variant,only month name is displayed.

Vignesh.V

 

[Khalid NGO]

Hi Vignesh,
You can show Variant#s with Data Labels:
Right Click any Data point > Format Data Labels > Label Options > Enable Series Name

But this will display Variant# with data points, not with Circles.

Another cheap way is insert shape manually

 

[Vignesh Veerasamy]

Hi Vignesh,
You can show Variant#s with Data Labels:
Right Click any Data point > Format Data Labels > Label Options > Enable Series Name

But this will display Variant# with data points, not with Circles.

Another cheap way is insert shape manually

Dear Khalid,

Thanks for reply.Insert shape is not getting copied when I am trying to make a bitmap image calling data from Excel to outlook,hence requested for default functionality.

Thanking you.

 

[Nebu]

Try doing one more Doughnut Chart from the same data set and place it on the top of the other and make it transparent. I guess you can get the desired result.
Something like the attached...

 

[Faseeh]

Hi All,

This is a general comment and i am not discouraging any one. I think a simple bar char or stacked bar chart will be more easy to understand and interpret then this doughnut chart. Although this will look more fancy.

 

[Vignesh Veerasamy]

Hi All,

This is a general comment and i am not discouraging any one. I think a simple bar char or stacked bar chart will be more easy to understand and interpret then this doughnut chart. Although this will look more fancy.

Dear Faseeh Sir,

I too suggested the same to user for going of stacked type...but user requested this...as always they have a point that it their requirements should be obtained after various struggles....so posted here to our group gurus.....

 

[Vignesh Veerasamy]

Hi All,

This is a general comment and i am not discouraging any one. I think a simple bar char or stacked bar chart will be more easy to understand and interpret then this doughnut chart. Although this will look more fancy.

Dear Nebu,

Thanks for efforts....got the variant names.....

 

[Nebu]

Cool

 

[Khalid NGO]

@Nebu that was cool, thanks for backing up.

 

[Faseeh]

There is a tool available as a freeware for chart labeling named "XY Chart Labelar" i suggest to try it. It will make things a lot easier.