James_Latimer
Active Member
- Joined
- Jan 20, 2009
- Messages
- 415
Excel 2007
Hello, I was wondering if someone could point me in the right direction please.
Is there a way to find the position of the upper most stacked column within a graph?
The reason i ask is because I have a stacked column graph, i am wanting to have a data label on the upper most column that displays a total all of the values within the stack. The only way i know how to do this is to add a text box to the graph and point that to the relevant value (this bit is working fine).
I need to be able to position this text box so that it always appears at the top of the upper stack. Without the syntax for accessing the bar positions i am stumped (if at all you can do that).
If anyone could let me know or offer a better alternative then it would be sincerely appreciated.
Many thanks in advance!!!!!
Hello, I was wondering if someone could point me in the right direction please.
Is there a way to find the position of the upper most stacked column within a graph?
The reason i ask is because I have a stacked column graph, i am wanting to have a data label on the upper most column that displays a total all of the values within the stack. The only way i know how to do this is to add a text box to the graph and point that to the relevant value (this bit is working fine).
I need to be able to position this text box so that it always appears at the top of the upper stack. Without the syntax for accessing the bar positions i am stumped (if at all you can do that).
If anyone could let me know or offer a better alternative then it would be sincerely appreciated.
Many thanks in advance!!!!!
