Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatic 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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatic repositioning data labels subset when chart updates
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 igottaknow wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatic repositioning data labels subset when chart updates
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. "igottaknow" wrote: 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatic repositioning data labels subset when chart updates
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/ _______ "Kokomojo" wrote in message ... 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. "igottaknow" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
insert data labels from range not used in chart | Charts and Charting in Excel | |||
Macro to add labels to data points in an xy scatter chart | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How do I get my data labels on a pivot chart to retain their form. | Charts and Charting in Excel |