I came across this tutorial for creating a radar pie chart, and let me say it is fantastic! The problem I'm having is that I need the chart to contain 10 or even 12 segments, but I cannot figure out how to add additional categories into the data sheet and have them respond the way they're supposed to in the chart. There's got to be a way to copy/paste, and then reconfigure some of the formulas in the copied cells. But I'm not sure what adjustments need to be made.

Any advice at all would be greatly appreciated!!

  • What have you tried? This looks easy: there is a workbook region with 8 data rows. What happens when you add rows to that region? – G-Man Feb 12 '15 at 5:35
  • Hi G-man. I have successfully added the rows. And the new pie segments appear just fine, with the correct labels and such. But the problem is that that the pie segments do no respond to a change in the value and "fill in" like they're supposed to. No matter what I change the value to, the pie segment remains empty. If you're so inclined, here is a sendspace link to the actual file I'm working with. – Slim Jim Feb 12 '15 at 14:26

In the link you posted, the tutorial starts out with 8 data rows.

You want 10 or 12, so start out with 10 or 12 and follow the steps.

It should not really matter how many rows of data you start with. You just need to adjust the ranges in the formulas to cover the ranges that you use.

  • Thanks tevlyn. I'm unable to start from scratch and reproduce the chart following the steps. I spent way too much time trying that and it didn't work. However I am able to add new categories and get the slices to look the way they should. However the segments of the chart do not fill in when I adjust the value column for any of the new rows I've created. I can get the angles correct, segment weight, labels, etc. But the color function doesn't work. Can you tell me where I might find that setting? I wonder if I just need to choose the color for the new segments somehow? – Slim Jim Feb 12 '15 at 12:37

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.