chartsmicrosoft excelmicrosoft-excel-2010
I have created a drop down list for use in each row (for the purpose of categorising). I'd like to graph the selected data (i.e the column of drop down lists) into a graph, probably a pie chart.
If I set the column as the data source to the graph it puts the selected values into the title region.
Can someone provide me with a link to a web page on how to do this?
Here are the steps you need to follow. I'm using a Pivot Chart, as suggested by Longhorn213. While you have the table selected:
Hit the Finish button You should now have two new tabs in the spreadsheet. One will have an empty chart and the other will have an empty pivot table. Select the sheet with the empty pivot table. Then:
Drag the Date field from the Pivot Table Field List to the area in the pivot table marked Drop Row Fields Here You should now see EVERY time stamp listed in the row.
Right click on the Date header in the Row and select Group and Show Detail -> Group
Highlight that you want to group by Hours and then hit the OK button Note that if your data spans several days/months, you MUST select both Days and Months in addition to Hours to further order the data.
Drag the n1 field into the area marked Drop Data Items Here
Drag the n2 field over top of the n1 data and drop it This will cause a new row header called Data to appear beside the Date header.
Drag the new Data header to the area marked Total and drop it there You now have the basic structure of the table that you want.
Drag the n3 and n4 fields into the data area, completing the table you want Now you can switch back over to the new chart sheet that was created. You should see the default type of chart with all your data.
Right click on the Chart Area and select Chart Type...
And we're done! I'll check back later and clarify anything you need.
This is how I do it:
Add a column and fill it with 1 (name it Count for example)
Select your data (both columns) and create a Pivot Table: On the Insert tab click on the PivotTable | Pivot Table (you can create it on the same worksheet or on a new sheet)
On the PivotTable Field List drag Country to Row Labels and Count to Values if Excel doesn't automatically
Now select the pivot table data and create your pie chart as usual.
P.S. I use the pivot table for I update the data on a regular basis, then I just replace the "Country" data and refresh the pivot table.
Best Answer
I would first create a table that calculates the data you need to display - with the given information I'm assuming this will be a list of the categories, along with the number of times each one appears in the data.
The easiest way to do this is via a PivotTable and Chart.
Otherwise, you can generate one yourself with a simple bit of fomula work - something like the below will total up the instances of each category (assuming the list is in col
EonOtherSheet- adjust as required), which you should easily be able to build a pie chart from.