pie chart creation using text values

Hi all,
I am trying to figure out how to create a pie chart from a column that
utilizes text values. Basically, I have a column of 91 records that are
broken into 3 values in the column: ns, nt, nu. I want to make a chart
of the percentage of those values in that column. I am having a
difficult time of it.
TIA,
Randy


--
araki
------------------------------------------------------------------------
araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
View this thread: http://www.excelforum.com/showthread...hreadid=272150

You can summarize the data with a Pivot Table, and create a chart from that.

Add a heading to the list of items, e.g. Code
Select a cell in the list
Choose DataPivotTable and PivotChart Report
Select PivotChart report (with PivotTable report), click Next
Select the Data range, click Next
Click Layout
Drag the Code button to the Row area
Drag Code again to the data area, where it will become Count of Code
Click OK, click Finish

A column chart will be created.
To change it to a pie chart, select the chart and choose
ChartChart Type.


araki wrote:
Hi all,
I am trying to figure out how to create a pie chart from a column that
utilizes text values. Basically, I have a column of 91 records that are
broken into 3 values in the column: ns, nt, nu. I want to make a chart
of the percentage of those values in that column. I am having a
difficult time of it.
TIA,
Randy




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html