Pie Chart / Target Chart Combo

[dullard]

Is there a program that will let you make a target chart (a series of concentric rings), slice it up like a pie chart (a series of radial slices), and write text in the resulting areas?

I know I could do it with paint. But I was looking for something easier. Excel and other graphing programs I've seen will let you do one or the other but not both.

 

[mayest]

Do you have an example of the "target chart" that you are trying to reproduce? I don't think I've ever seen what you are describing. Excel has the Doughnut chart, but I assume that you know that. Anyway, many things are possible in Excel if you know a few tricks, so an example (with some data, if possible) would be helpful.

 

[dullard]

I did this in paint, so it is a bit crude. I want something like on the right. Picture.

Thanks.

 

[mayest]

Ok, I'm stumped. I think that I understand what you want: a pie chart where each slice is a doughnut chart. Or something like that. The best I can do is tell you to check out this page. It isn't exactly what you want, but it may give you ideas. In particular, look at the pie charts in the last section titled "Central Pie with Outlying Segments."

 

[dullard]

None of them quite do it for me, but it did give me an idea. I could create a donut chart, for the two outer rings and a pie chart for the inner portion. Then lay one on top of the other. It'll be a pain in the neck to start, but once it is set up, it may look like what I want.

 

[mayest]

Yes, I was thinking of something like that as well. You do know that you can create two (or more) charts inside of one chart, right? You do not have to physically overlay one chart on top of another. If not, let me know and I'll give you the steps.

 

[dullard]

Got instructions here. I used the filled doughnut instructions.

I didn't know Excel could do those types of things. It seems way overly complicated, but it'll do the job.

 

[mayest]

I'm glad that you got it figured out, and thanks for the link. That confirms my first point: anything is possible if you just know the tricks. I did not know this particular trick, especially the fact that pie charts have axes (which is really well hidden).