LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
danielle
 
Posts: n/a
Default how do i make a chart using text information?

I'm trying to make a pie chart using words as the information to compute =

rather than numbers - is this possible to do? like for example if i =
wanted to=20
calculate the percentage of french students, spanish students, and =
english=20
students in a class of 30, and i set up my column like this:

STUDENT'S NATIONALITY
french
french
english
spanish
english
spanish
spanish
spanish
french
.....

would it be possible to have excel make a pie chart that shows the=20
proportion of french to english to spanish students in the class? or do =
i have=20
to set up my information differently?

-danielle
 
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
Dynamic Text in a Chart hlsr2003 Excel Discussion (Misc queries) 1 February 10th 05 12:43 AM
How to make a stacked bar chart using time? Jon Peltier Charts and Charting in Excel 0 February 3rd 05 05:56 AM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM
How to Make the text blink in Excel? rajesh aiyappa Excel Worksheet Functions 3 October 29th 04 09:24 PM


All times are GMT +1. The time now is 11:32 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"