G
Guest
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
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