Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Labeling points on a line chart
I have a chart that has 5 lines that track the error percent for specific
tables in our data conversion. I have some code that pulls in the date when it goes out and populates the data series - and I would like for each date to be the label for each of the data points on the chart. Is it possible to specify what the labels should be? I can hardcode them ahead of time or make the labels a series of some sort, but I'm not sure how. Any help would be appreciated! -- Regards, John |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Labeling points on a line chart
Put the labels in a range in your worksheet (your code could put the
timestamp by every measurement). Then use a utility like one of these to apply labels in this range to the points: 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 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "John Brenner" wrote in message ... I have a chart that has 5 lines that track the error percent for specific tables in our data conversion. I have some code that pulls in the date when it goes out and populates the data series - and I would like for each date to be the label for each of the data points on the chart. Is it possible to specify what the labels should be? I can hardcode them ahead of time or make the labels a series of some sort, but I'm not sure how. Any help would be appreciated! -- Regards, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
labeling data points in a scatter graph | Charts and Charting in Excel | |||
Accessing Points in a Line Chart | Charts and Charting in Excel | |||
Labeling x,y data points on scatterplots | Charts and Charting in Excel | |||
labeling data points on a scatter chart | Charts and Charting in Excel | |||
Line chart with two series; how to add points to one and not the other? | Charts and Charting in Excel |