Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .