LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 207
Default Problem charting two points of data

Patrick C. Simonds,
This is what I did to get a pie chart on the worksheet with the values:
In Cell A1 "Total Number of Employees to Trained"
In Cell A2 "51"

In Cell B1 "Total Number of Employees toTrain"
In Cell B2 "195"

I select cells A1:B2 (as you did).
I select the chart wizard. Select Pie. The default is the upper left pie
chart sub-type.
Select "Next" to preview the chart.
Select "Data Labels" tab. Select the "Value" in "Label Contains" area.
Select "Next" and select as "As object in:"
Then "Finish"

hth
Dennis

"Patrick C. Simonds" wrote:

What am I missing? I want to chart the data below using a pie chart with a legend that tells me what each of the pieces of the pie represents. I tried selecting cells A1 and A2 and I have tried selecting cells A1:B2. All I end up with is a legend

51 Total Number of Employees to Trained
195 Total Number of Employees to Train






 
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
CSV Charting Problem Quicksilver2002 Charts and Charting in Excel 1 June 6th 06 06:58 PM
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
Charting Data Series vs. Data Points? Tommy Z. Charts and Charting in Excel 4 November 29th 05 11:23 PM
Blank cells and Charting multiple data points willisj Charts and Charting in Excel 1 November 10th 05 12:29 AM
Multi-sheet data charting problem Jim M Charts and Charting in Excel 2 May 6th 05 01:13 AM


All times are GMT +1. The time now is 05:04 PM.

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"