Hello all,
Is there any way that I can place a text as fixed position over the highest value on the Y axes in a chart with VBA?
Thanks in advance,
Joachim
Hello all,
Is there any way that I can place a text as fixed position over the highest value on the Y axes in a chart with VBA?
Thanks in advance,
Joachim
Does it have to be a text box? Could you make do with a data label from a dummy series.
It has to be a text box because the macro is going to format already existing graphs that uses a text box to display what currency the data is shown in.
Please Login or Register to view this content.
Oh, thank you! But I see that the text box is positioned ontop of the higest value of the data series? What I want to is that I want to position It above the actual axis.
The axis left includes axis tick labels, so you may need to use activechart.PlotArea.InsideLeft property.Please Login or Register to view this content.
Perfect! Thank you, Andy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks