This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I want to create a sweet spot pie graph identifying several regions as small circles on a big region. Is there anyway to set this up?
horizonal axis -?
vertical axis - ?
EX:
US 100%(big circle)
New England 20% inside
NY 50% inside
New Jersey 20% inside
New england concentration of 20% sales are in the 1-10million range, ny concentration are in the 525-20million range.... etc,.
is it doable?
Thanks,
EA
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
This may not be possible in Excel.
However you may create a Pie of Pie chart and see if it helps.