Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 0 down vote accepted

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 E on OtherSheet - adjust as required), which you should easily be able to build a pie chart from.

    A               B
1   ham             =COUNTIF(OtherSheet!E:E,A1)
2   cheese          =COUNTIF(OtherSheet!E:E,A2)
share|improve this answer
Spot on. Thanks - went for second option. – Mr Shoubs Jan 10 '11 at 11:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.