| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data series labels
How do I show only the last data label for each series in a chart and allow
them to update as new data is added to each series? I will try to use VBA if this is the only way possible. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data series labels
Hi,
Depending on your chart and data VBA may not be required. http://www.andypope.info/charts/Labellast.htm Or Jon Peltier has some code. http://peltiertech.com/Excel/Charts/LabelLastPoint.html Cheers Andy cpt7750 wrote: How do I show only the last data label for each series in a chart and allow them to update as new data is added to each series? I will try to use VBA if this is the only way possible. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data series labels
Thank you Andy. This seems like a neat way to accomplish what I asked. Any
way, I will check it out. As my chart has 30+ series and is not static (# of series may change daily), I may end up doing it in VBA. Charles "Andy Pope" wrote: Hi, Depending on your chart and data VBA may not be required. http://www.andypope.info/charts/Labellast.htm Or Jon Peltier has some code. http://peltiertech.com/Excel/Charts/LabelLastPoint.html Cheers Andy cpt7750 wrote: How do I show only the last data label for each series in a chart and allow them to update as new data is added to each series? I will try to use VBA if this is the only way possible. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data series labels
Hi,
30+ series, really? That's got look like a plate of spaghetti :) Maybe you need to re consider the chart type. Cheers Andy cpt7750 wrote: Thank you Andy. This seems like a neat way to accomplish what I asked. Any way, I will check it out. As my chart has 30+ series and is not static (# of series may change daily), I may end up doing it in VBA. Charles "Andy Pope" wrote: Hi, Depending on your chart and data VBA may not be required. http://www.andypope.info/charts/Labellast.htm Or Jon Peltier has some code. http://peltiertech.com/Excel/Charts/LabelLastPoint.html Cheers Andy cpt7750 wrote: How do I show only the last data label for each series in a chart and allow them to update as new data is added to each series? I will try to use VBA if this is the only way possible. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Series Labels in Area Chart | Charts and Charting in Excel | |||
| data series and axis labels | Charts and Charting in Excel | |||
| How to add data labels from a series not displayed on a chart | Charts and Charting in Excel | |||
| XL Chart: Separately align series and value data labels | Charts and Charting in Excel | |||
| XL Charts: Let my mouse drag all data labels for a whole series. | Charts and Charting in Excel | |||
Linear Mode
