 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / December 2006Automatic repositioning data labels subset when chart updates
Several Excel charts. 25-month period. Each month a data point. Only 1st, middle and last data points labeled. As data is updated each month, the data labels do not shift up/down with the new first, middle, last data points. Manual repositioning is time consuming. Can the data labels be made to automatically shift with the chart line? If so, can they also be forced to remain within the plot area? I'm using Excel 2002 (10.5815.4219) SP-2 Hi, Can you use a second series to hold the data label positions This example do last point and Min/Max but can be adapted to do first/middle/last. http://www.andypope.info/charts/Labellast.htm Cheers Andy > Several Excel charts. 25-month period. Each month a data point. Only 1st, > middle and last data points labeled. As data is updated each month, the data [quoted text clipped - 5 lines] > > I'm using Excel 2002 (10.5815.4219) SP-2  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Hi, Did you ever figure out how to do this. I have a similar situation where I have 2 years on a chart and each month, I add a month. I would like the oldest month to disappear and the new month to appear on the chart. Is there a way to achieve this automatically? Thanks for you help. > Several Excel charts. 25-month period. Each month a data point. Only 1st, > middle and last data points labeled. As data is updated each month, the data [quoted text clipped - 5 lines] > > I'm using Excel 2002 (10.5815.4219) SP-2 The way to accomplish this is to add an XY series to the chart which contains only the points you want labeled. Make the points invisible (no markers, no lines), and add data labels. Link the data labels to cells in the worksheet which use formulas to construct the label you want displayed at each point. Use one of these free Excel utilities to add labels to a series using cells in the worksheet: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ > Hi, > [quoted text clipped - 18 lines] >> >> I'm using Excel 2002 (10.5815.4219) SP-2 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.