Charts

[Nick]

Hi,

Im trying to make a chart in Excel, I have a list of addresses and
states, I want to make a pie chart of the states to show what percentage of
all the states each state is. But if I select the columns and click on the
chart and choose pie, in the end I just have a line. Ok im not that great at
this yet, just looking for a little help.

 

[Debra Dalgleish]

You can create a pivot table from the data, with State in the Row area,
and State again in the Data area, where it will become Count of State.

There are pivot table instructions and links here:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

Then, create a chart from the pivot table.

 

[Nick]

Thanks,
I will check that out.

Nick

You can create a pivot table from the data, with State in the Row area,
and State again in the Data area, where it will become Count of State.

There are pivot table instructions and links here:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

Then, create a chart from the pivot table.