Click the new series you added (scatter graph) > Edit. Click on the doughnut and amend as per original instructions of 90degree angle of first slice, hole of 80% etc - Now go to Chart tools > Design > Select data. Change the doughnut series back to a doughnut graph (Excel would have changed it) and change the new series you've just added to scatter with straight lines > OK. Select the chart > Chart tools > Design > Change Chart Type. You should see a second doughnut ring around the original. Give the series a name and leave the value as one (1). With Excel 2013: - Instead of creating a new scatter graph for the B6:C8 data, click the doughnut graph > Chart tools > Design > Select data. One improvement I've made is to combine all onto one graph for simplicity. Great workaround instead of downloading an add-on, thanks!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |