Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Labeling Data Series on an XY Scatter
I need to label a data series on an XY Scatter. Currently Excel only has the
option to label and individual point with the series name, I want to label the entire series of points just once with the series name, even if inputs are changed. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Labeling Data Series on an XY Scatter
Select the point you want to label (two single clicks, one for the series,
one for the point itself). Press Ctrl+1 to format the point, then add a data label using the Series option. This point will carry the series name as its label, even if the data or the series name change. In 2007, select the point (two clicks again). Go to the Chart Tools Layout tab, click on Data Labels More Data Label Options, choose the Series Name option. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Dan" wrote in message ... I need to label a data series on an XY Scatter. Currently Excel only has the option to label and individual point with the series name, I want to label the entire series of points just once with the series name, even if inputs are changed. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Labeling Data Series on an XY Scatter
I have another issue... I understand that label but I need to assign the
series label to the left most data point that is plotted on the chart. Is there an if statement that can test this then place the label next to that data point? Basically the label is correct but the data point that I want the label next to varies. "Jon Peltier" wrote: Select the point you want to label (two single clicks, one for the series, one for the point itself). Press Ctrl+1 to format the point, then add a data label using the Series option. This point will carry the series name as its label, even if the data or the series name change. In 2007, select the point (two clicks again). Go to the Chart Tools Layout tab, click on Data Labels More Data Label Options, choose the Series Name option. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Dan" wrote in message ... I need to label a data series on an XY Scatter. Currently Excel only has the option to label and individual point with the series name, I want to label the entire series of points just once with the series name, even if inputs are changed. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Labeling Data Series on an XY Scatter
There are two options that don't require a bunch of VBA.
1. Assign labels to all points. linking the labels to cells in the worksheet. In these cells, have some kind of formula that determines if a cell is the leftmost, and if so the label is whatever it should be, otherwise the label is blank. Use one of these free utilities to link a set of labels to a range of cells: Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm John Walkenbach's Chart Tools, http://www.j-walk.com/ss/excel/files/charttools.htm 2. Use another series which has X and Y values for only the leftmost point of each series. Add the appropriate labels to this series, and hide the points by using no line and no markers. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Dan" wrote in message ... I have another issue... I understand that label but I need to assign the series label to the left most data point that is plotted on the chart. Is there an if statement that can test this then place the label next to that data point? Basically the label is correct but the data point that I want the label next to varies. "Jon Peltier" wrote: Select the point you want to label (two single clicks, one for the series, one for the point itself). Press Ctrl+1 to format the point, then add a data label using the Series option. This point will carry the series name as its label, even if the data or the series name change. In 2007, select the point (two clicks again). Go to the Chart Tools Layout tab, click on Data Labels More Data Label Options, choose the Series Name option. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Dan" wrote in message ... I need to label a data series on an XY Scatter. Currently Excel only has the option to label and individual point with the series name, I want to label the entire series of points just once with the series name, even if inputs are changed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
labeling data points in a scatter graph | Charts and Charting in Excel | |||
Scatter plot with two data series having common x-values | Charts and Charting in Excel | |||
multiple data series in an x-y scatter chart - Excel 2003 | Charts and Charting in Excel | |||
labeling data points on a scatter chart | Charts and Charting in Excel | |||
Data Point labeling | Charts and Charting in Excel |