| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
getting data labels on xy chart from additional plot area
Good ol' Lotus! I remember those days...
"Shane Devenshire" wrote: Hi Adri, (tongue in cheek) - just use Lotus 1-2-3 version 1. Yes you could do this in the very first version of lotus without any add-ins or tricks, that was back in 1982, before I was born. We still don't have it in Excel 2007, 25 years later? Cheers, Shane "Adri S." wrote in message ... WOW! The Chart Labeler was exactly what I needed. Thank you so much for providing these links. Problem solved. "Jon Peltier" wrote: Check out these useful (and free) utilities: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Adri S." wrote in message ... 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 | |
|
|
Similar Threads
|
||||
| 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 | |||
![Adri S.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
