LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default getting data labels on xy chart from additional plot area

I am creating a scatter chart that is designed to show trends in employee
performance. Employees are rated with 2 different tools, each using a 5 point
scale. I am able to plot the intersection of each tool rating without a
problem. However, I would like to be able to add a data label that is
employee name. When I add names to the data series, my xy chart now plots
each tool as a separate data point, not as an intersection.

So...when I use source data like below, the chart looks fine, but employee
name is not included.

Tool 1 Tool2
-------------------
4 5
3 4
5 5

So Tool 1 is the x axis and Tool2 is the y axis, and the chart plots one
data point for each row.

When my data source appears as below, the chart now plots one data point for
each rating, instead of the intersection of Tool1 and Tool2.

Tool 1 Tool2
-------------------
Bill Smith 4 5
Sue Jones 3 4
Mary Allen 5 5

So, I need help plotting Tool 1 and Tool2 on an xy chart, and be able to
have the employee name appear as a data label. Thank you in advance!
 
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
Data Series Labels in Area Chart Reb Charts and Charting in Excel 4 April 22nd 23 04:10 AM
How do i fix y labels inside plot area? rowingj Charts and Charting in Excel 2 July 18th 06 05:14 PM
How to increase chart area without affecting plot area? [email protected] Charts and Charting in Excel 2 April 21st 06 09:05 PM
excel chart plot area not showing data samm Charts and Charting in Excel 1 August 25th 05 11:29 AM
How do I move the Category Axis labels outside of the Plot Area? Brian Shoun Charts and Charting in Excel 1 January 7th 05 05:42 PM


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