Creating a "Doughnut" with Label Values

I am looking to create a doughnut chart using the values of 3 labels. (Label1, Label2, Label3)
These values would represent a portion of the total with the total being the sum of Labels 1,2,3

Any insight on how to begin/achieve this?

See the attached workbook for a simple Doughnut Chart, including instructions on how to create the chart manually. This should get you started. I will post an update in a few days with more robust capabilities.

Lewis

LJ,

Thanks for the sample file. My biggest problem with charts right now is that I am not working with numerical data on most of them but instead one to do "counts of occurrence". The specific "doughnut" in this file is based off the label values that you helped me create (Label4-7). Specifically what I am trying to do is make a doughnut showing the number of each "Audit" type.

Jared

My biggest problem with charts right now is that I am not working with numerical data on most of them but instead one to do "counts of occurrence".

I know that from working on your other thread which I am currently working on.
http://www.excelforum.com/excel-prog...eed-macro.html

I'll post something in that thread in a couple of days.

In the mean time try formulas like the following, which I am using in the other thread.

Please Login or Register  to view this content.

Lewis