pie chart creation using text values

  • Thread starter Thread starter araki
  • Start date Start date
A

araki

Hi all,
I am trying to figure out how to create a pie chart from a column tha
utilizes text values. Basically, I have a column of 91 records that ar
broken into 3 values in the column: ns, nt, nu. I want to make a char
of the percentage of those values in that column. I am having
difficult time of it.
TIA,
Rand
 
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 Data>PivotTable 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
Chart>Chart Type.
 
Back
Top