1 Reply Latest reply on Sep 5, 2018 9:51 AM by swaroop.gantela

# how to make two overlapping circles whose sizes are associated with two measures?

What's the data?

The example workbook attached has one measure variable "solar radiation" for each hour across a whole year.

What do I want to do?

I want to create a chart in which two overlapping circles sharing the same center.

The size of one of the circles in grey color shall correspond to the sum of the solar radiation measure, and the size of another one with blue edge shall be associated with a parameter which can be adjusted.

What's the problem?

However, I'm unable to find a solution following the suggestions to make a donut chart. The relative sizes of both circle will not change if the values of the measure or the parameter is changed.

• ###### 1. Re: how to make two overlapping circles whose sizes are associated with two measures?

Joe,

I don't think I quite got there, but maybe this can give ideas.

Instead of using the stock shapes, I plotted the points of a circle

using the method described inKen Flerlage's excellent post:

Beyond "Show Me" Part 2: Trigonometry - Ken Flerlage: Analytics Architecture, Strategy, & Visualization

I made a sheet with two columns: Type (Radiation/Baseline) and Point (increasing integers to 37).

Then X became:

IF MAX([Type])="Baseline" THEN COS(SUM([Angle in Radians]))*SQRT([baseline value]/PI())

END

And Y the same except with SIN.

The graph was resizing such that the baseline always filled the grid,

so I fixed the axes to allow the baseline size to change with the parameter.