# Need help with Excel 97 (Statistical Functions) **URL:** \ **Category:** Factual Questions\ **Created:** [March 22, 2001, 7:45pm UTC](https://boards.straightdope.com/t/need-help-with-excel-97-statistical-functions/59039 "2001-03-22T19:45:31Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Gambit](https://avatars.discourse-cdn.com/v4/letter/g/e0b2c6/32.png) [@Gambit](https://boards.straightdope.com/u/Gambit)\ **Post date:** [March 22, 2001, 7:45pm UTC](https://boards.straightdope.com/t/need-help-with-excel-97-statistical-functions/59039/1 "2001-03-22T19:45:31Z")
A few brief questions: How do you create a box plot in Excel 97? (Assume that all of the mathematical data is figured out.) When you’re creating a pie chart, how do you label the individual slices non-numerically? (Whenever I create the pie, Excel defaults to percentage values–I need each slice of the pie to display not only the percent value but also the name of what it represents.) Your help with this is greatly appreciated–I’m going a bit nuts trying to figure this out. (Excel’s Help feature is no help at all, I’m afraid.) ---
**Author:** ![D18](https://avatars.discourse-cdn.com/v4/letter/d/c57346/32.png) [@D18](https://boards.straightdope.com/u/D18)\ **Post date:** [March 22, 2001, 8:04pm UTC](https://boards.straightdope.com/t/need-help-with-excel-97-statistical-functions/59039/2 "2001-03-22T20:04:41Z")
> [@](#): > > \*Originally posted by Gambit \* > \*\* > When you’re creating a pie chart, how do you label the individual slices non-numerically? (Whenever I create the pie, Excel defaults to percentage values–I need each slice of the pie to display not only the percent value but also the name of what it represents.) > > \*\* 1. Highlight the chart. 2. Under CHART, select “chart options”. 3. Click “data labels” tab 4. Select “show label” or “show label and percent” as needed I’m using a later version of Excell, but I’m almost positive that I used to do this in '97 D18