Programmatically placing data labels

**jsmath22** · 11-06-2009, 12:10 PM

I have a chart that is displaying percents but I want to add a count to it, which is whole numbers so I have to display the data labels only to not dwarf the percent bars. I need these data labels to appear directly above the series bar for the corresponding category and it is always changing so I can't use
DataLabel.Left=somenumber
DataLabel.Top=somenumber
I have to find the height of the corresponding series bar and then go
DataLabel.Left=height of bar + 1
or something.

Any help would be greatly appreciated!!

Thanks

**Andy Pope** · 11-06-2009, 12:30 PM

can you post example so we can better see and unsertand your problem

**jsmath22** · 11-06-2009, 12:51 PM

I have attached an example of the graph.

**Andy Pope** · 11-06-2009, 12:54 PM

No showing. Maybe the file is too big.

**jsmath22** · 11-06-2009, 01:19 PM

OK, there it is. Unfortunately I cannot post the actual graph, it is work, secure data, blah blah. The graph I am dealing with is a little bit more complex, there are 4 series I am plotting so putting the data label at the bottom makes it hard to see. So I need to take those numbers and put it directly above the bar.

So I need to assign
ActiveChart.SeriesCollection(1).Points(1)."height"
(but the height object doesn't exist) this to a variable.

**Andy Pope** · 11-07-2009, 07:24 AM

Add a dummy series and plot on the secondary axis.
Use the & values and the Count as the cateogry labels.

Then display the data labels showing category.