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