Unanswered: Creating a graph/chart to show what I want it to!
I'm trying to create a chart that shows what percentage of the total sales a particular number of part has. However when I tried to use a pie chart etc. it just shows the part number and not the amount/percentage. Below is an example of the data I am using. The four-digit numbers are in text format in an attempt to make it work!
You will have to sort the source data, Click on Series, Delete out the Part No series. In the Category Label put your series of part numbers, CLick OK
Right Click and go to chart options, On the Data labels Tab chose the options you want.
Oooh, that works, thanks! V pretty pie chart now Is that something I should have known? I usually just select the data and let Excel get on with it. If you don't mind, could you explain to me why I've just done that and how it works?
I don't know the proper answer to this but i will give it a go,
When you created the chart initally you probably had your part numbers set up as numbers and that you converted them to text hit F11 or hit the chart wizard then let Excel finish it off by itself.
Now Excel hasn't detected anything but data when you created the chart and is creating the chart off of your first series.
It's good to learn how to use all of the chart wizard in excel as in a case like this when you need numbers to be your labels excel want's to put them in as data as in this case.
It is also useful to learn how to chart from scratch in case you want to add more info to a chart like a target line against a bar chart etc.
Im not an expert on charting but i learned how to use the wizards when i had to.
a bit garbled i know someone will probably explain things better than me
Thanks for your help, David. I think I understand what you mean! I have another problem now though, that I've been puzzling over for a couple of days. I have a list of those four digit numbers and the amount of products that they are used in, from 1-6. Basically I want Excel to add up all the 1s. all the 2s etc and show them in a pie chart, to see which is the most popular number (1-6). Ideally I'd want it to show the four digit numbers as labels aswell. Am I asking too much? I know I could draw it by hand myself, but can Excel do that?