Counting & Charting Combined

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have a list of several hundred orders and I want to
graph where they ar coming from. So I want to count each
state and pir graph that. Is there an easier way than
going through the "Data, Subtotals, Count" then
copy/pasting the results into another worksheet then
graphing it from there? I just want to have a few clicks
if possible.
 
Jason -

If your data is arranged in nice columns, with state in one column and
numbers in another, you could make a pivot table, with state in the row
area and numbers in the data area. This table can then be charted.

You can make a pie chart from the pivot data, and when the table is
refreshed the chart will reflect the change. Unfortunately it will
change back to a column type pivot chart.

Or you could make a regular chart from the pivot data. Select a blank
cell away from the pivot table, start the chart wizard, select pie in
step 1 and in step 2, click on the Series tab, click Add, and select the
range of the pivot table with the labels (state names) and values. Be
careful not to select a pivot table button, or your chart will revert to
a pivot chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top