PDA

View Full Version : Replace Chart labels with Textboxs



Mano
07-13-2011, 12:50 AM
Hi All,

I'm struggling with a chart label formatting issue, any help with this regard is much appreciated.

Issue Description:

I was searching for a code to replace chart lables with textbox (as chart labels cant be resized) and I found some code on net to do this, however the textbox size comes out as 2.5 and it puts the textboxes onto the leftside of the chart and not exactly at the original label position.

1) Is it possible to generate text boxes that are not part of the chart. The main advantage of doing it this way is that I can select muliple boxes - then can do all sorts of formatting (including moving them around) on lots of boxes at the same time. I don't think I can do this with text boxes imbedded within the chart.

2) Is there a way to put the textbox exactly on the label.


I have attached the relavant file for your reference.

Regards,
Mano

CatDaddy
07-13-2011, 03:46 PM
yourTextBoxObject.linkedcell = "$A$1" ' or whichever cell you wish to link it to

http://vbadud.blogspot.com/2008/07/linking-text-box-to-excel-range-using.html