Pie within Pie chart

G

Guest

I need help in plotting pie within pie chart

Canada- 82%
US- 18%
within Canada I have to show the division 82% within
provinces



Any help would be much appreciated !

Thanks,
 
T

Tushar Mehta

Lay out the data as:
US 18%
Province 1 xx%
Province 2 yy%
....

Now, create a pie chart (pie of pie). Double-click the pie, and from the options tab select 'Split series by position' and set the 'Second plot contains the last x values' so that x=number of items in table less 1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top