Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving data labels around with VBA (and adding a line between two
Hello.
I am looking for a way to manage data labels in an automated charting procedure I am writing. The chart is a waterfall chart (I believe) and I'd like to be able to loop through each dataseries/column to find the height of the total column and then set the label for the total column to sit x points above it. There is a second issue I need help with. As the chart displays components of return for stocks and bonds, I'd like to place a line in between the last stock and the first bond shown. Is there a way that I can place this line dynamically (charts will like have different numbers of stocks and bonds - as will a particular chart over time). I think there is an add-in someone mentioned I could try downloading but I'd like to avoid that if possible. Thanks, Caro-Kann Defence |