5 Replies Latest reply on Jul 26, 2016 2:19 AM by khalid norat

# Is there a way to create an inverse circle chart by size?

Hello,

I have the following circle graph depicted below. As you can see, the large the sum number of records, the larger the size of the circle. However, the data that I am dealing with is actually more concerned about the groups that are smaller in number. Would it be possible to actually make a circle with "72" bigger than say a circle with "252"?

• ###### 1. Re: Is there a way to create an inverse circle chart by size?

create a calculated field  as Value * -1  drag this on to size box

as -252 is smaller then -72 the -72 circle will be larger.

Hope this helps let me know if you need screenshots to demonstrate

• ###### 2. Re: Is there a way to create an inverse circle chart by size?

However, when I created a field called "Negative Value"

And then dragged it into the "Size" box, it made all the circles the same size.

• ###### 3. Re: Is there a way to create an inverse circle chart by size?

Create a calculated field, and multiply the specific value with some number.  Drag calculated field on size and dimension to color and sales to text label.

for example check the below screen

Attaching the workbook for reference.

Regards,

Swarup

• ###### 4. Re: Is there a way to create an inverse circle chart by size?

It's not to create a calculated with value -1.

Multiple -1 * Number of Records

• ###### 5. Re: Is there a way to create an inverse circle chart by size?

calculated field should equal

[Number of Records] * -1

I wrote value as I didn't know which field you were visualising

if you change the calculated field to the one above it should fix your visualisation