Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cwling
 
Posts: n/a
Default making charts based on text categories

I have a column of nationalities and I want to make a pie chart to show the
percentage of each nationality. How do I do this?
  #2   Report Post  
Max
 
Posts: n/a
Default

Suppose you have this data in A1:B3

ABC 900
XYZ 1000
DEF 800

(Ref your subject line, you'd of course need the population *numbers* next
to the nationalities to plot the pie)

Select A1:B3
Click the "Chart Wizard" button
Choose "Pie" select the desired sub-type
Click Next and run through/complete the steps of the wizard

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"cwling" wrote in message
...
I have a column of nationalities and I want to make a pie chart to show

the
percentage of each nationality. How do I do this?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting based on Text within Text George Lynch Excel Discussion (Misc queries) 3 May 5th 05 07:58 PM
Multiple charts in ChartSpace; problems with double Categories hstaaks Charts and Charting in Excel 0 May 4th 05 02:46 PM
Multiple charts in ChartSpace; problems with double Categories hstaaks Charts and Charting in Excel 2 May 3rd 05 01:23 AM
Multiple charts in ChartSpace; problems with double Categories hstaaks Charts and Charting in Excel 0 April 29th 05 12:06 PM
How to auto-fill text based on text in another cell Jason Excel Discussion (Misc queries) 3 February 16th 05 08:40 PM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"