Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Series Labels in Area Chart | Charts and Charting in Excel | |||
How do i fix y labels inside plot area? | Charts and Charting in Excel | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
excel chart plot area not showing data | Charts and Charting in Excel | |||
How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel |