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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com