Help : Polar bubble chart

[anishms]

The attached sample file is found available from one of the post in this forum
Polar bubble chart - Going Crazy!! Definately need help. | Chandoo.org Excel Forums - Become Awesome in Excel

I have modified it little bit as per my requirement, but I'm unable to figure out to plot the risk count given in 'column A' against the respective verticals. The file I downloaded had only 7 verticals.

Any help on this is greatly appreciated.

Thanks in advance!

The expected result is given below

 

[vletm]

anishms
What would be Your 'a bit'?
The original file's A-column is like fixed values (~row number) and no connection with output.

 

[anishms]

Thanks for your response vletm. I know you helped the member who originally posted it almost a year back.
I just added one vertical.
Yes, in the original file it is was showing "Risk ID" in all the bubbles.

 

[vletm]

anishms
That 'Risk ID' is name of Series and same for all shown data.
As You see, it's that header-text.
If You would like to see eg A-column values there
then do like below with the original file

 

[anishms]

anishms
That 'Risk ID' is name of Series and same for all shown data.
As You see, it's that header-text.
If You would like to see eg A-column values there
then do like below with the original file
View attachment 73572

Done. Thankyou
But the position of the bubble in respective sectors is a problem as I have one additional sector

 

[vletm]

anishms
'A problem' ... hmm?
...is that You won't write What would be Your 'a bit'?
Okay ... I ( anishms ) just added one vertical.
You seems to modify background picture ... was that all?
... formulas don't care about that picture.
Did You modify something else to get expected results?
If not, then try to find - what should do? from 7 sectors (left) to 8 sectors (right)

Same 'thing' should take care if make any changes... add or take away.