How to Custom Label a Single Data Point When Adding New Series

[DixiePiper]

I have a two part problem/question:
1. I need to label a specific data point on a series.
2. I need that label to have custom text & the value of the data point (e.g. "PTA: $108,750)

The details:
The chart is generated by user inputs. I have a process that creates the chart and uses multiple sub processes to add the series, scale the x-axis, and modify the chart legend. Manipulating the series by number isn't reliable as it may be the 7th or 11th series, depending on user inputs. To keep the chart reliable, each time the user navigates to the worksheet containing the chart, it deletes and re-adds. What I have so far is working *perfectly* for what I need. I want to be able to label the specific point when the series is created.

Here's the code I'm using to add the new series:

Please Login or Register  to view this content.

Thank you in advance for any assistance.

[MrShorty]

This page has code that will label the last point in a series. It should be easy enough to modify this code to label any single point in the data series with whatever text you would like: http://peltiertech.com/Excel/Charts/LabelLastPoint.html

[DixiePiper]

Thank you. I probably should have mentioned that I'm relatively new to VBA programming. I have looked at the link you provided (both now and during my original internet searches) and either it doesn't do what I need or I cannot figure out how to modify it.

Of the eight or twelve series present on the chart, I need to modify one specific point on one specific series. At the time the series is added it could be the 7th series or the 11th series but it's always the 5th data point. Every reference I've seen about data labels includes some reference to activating the series collection by number or (as in Mr. Peltier's post) labels points on every series.

I promise, I have tried to figure this out and just cannot.

Lisa

[DixiePiper]

Apparently sometimes you just need to take a break. I figured out how to add the label to the point I want but I cannot figure out how to get it formatted.

The revised code looks like this:

Please Login or Register  to view this content.

The result is the following data label: PTA: 112495000

I need to be able to format the number portion to, at a minium, show $112,495,000

[MrShorty]

I would suggest using the Format() function. https://msdn.microsoft.com/en-us/lib.../gg251755.aspx I would expect a format code such as "$000,000,000" would be close to what you want.