Im trying to turn a series of date into a pie chart. To simplify the issue, let's say I have a name in A1, an age in A2, and a height in A3. Let's say I have 3 people filling cells B13. When I highlight the area and attempt to make the date into a pie chart, all I get is a solid pie chart, with the legend on the right saying series 4-16. Is there a trick to getting the chart to separate into different colors?
Use the chart tools at the top after you create the chart. what version (year) of excel are you using?
2007. If I highlight the entire data table, it just gives me a solid color instead of each individual category being its own color.
you should be able to fill them in using the format option. I use 2010 though, I know 2007 is different, so I cannot tell you for sure, but there should be some format option for the chart
What is your actual data? Pie charts are typically only two dimensions (two columns) When I tried something similar to what you described it picked one of the columns to chart
Pre-Departure $546.00 6% Transoportation 1,556.10 18% Housing 1,600.00 18% Education 2,485.83 28% Personal Expenses 1,495.00 17% Miscellaneous 1,057.52 12% Im well aware that isnt going to format correctly, Im pretty computertarded. Like I said, If I highlight the entire data table I just get a pie chart that is one color. I would suspect that there is some way I should be able to highlight the whole thing and it would split each category into its own slice of the pie, so to speak.
A pie chart is one dimension For example if you had three cells highlighted that equaled 100, 50, and 50, and clicked insert pie chart, you would get a chart broken into three sections. 2 of these sections would take up 25% and one section would take up the other 50%. if you highlighted a 2x3 range then it would simply use the first set of three as the labels and the second set of three as the data. right click the pie chart and click 'select data' to get more information on what the chart is showing you. don;t highlight the percentages. just the first two columns (the label and amount). then click create pie chart. excel will handle the percentages for you.
^ like he said, one dimension. The "name" will be the labels on the pie chart. What do you want the pie chart to show, the percentages (which must all add up to 100%)? Select only the percentages... alternatively (hold CTRL while you drag) select the names column to have labels on the percentages. EDIT: after his edit, I see what he means. Do what tallanvor says.