Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.AxisTitle
Hi Peter,
This will link the axistitle to the cell B1. .Axes(xlCategory, xlPrimary).AxisTitle.Text = "=" & Range("B1").Parent.Name & "!" & Range("B1").Address(ReferenceStyle:=xlR1C1) Any changes in B1 will automatically be reflected in the chart. Note that you can not append text, i.e. (lbs), when the text is linked. Therefore this must be done within the cell B1. peter wrote: i'm sorry, i should have clarified that B1 has contents that can change, thus the need for having B1 read into the title. for example B1 might say Drive, or it might say Force, etc.... -----Original Message----- can anyone tell me how I can do this? cause i'm doing it wrong.... this line of code: ..Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = Range("B1").Value & " (lbs)" the cell contents of B1 just has the following: Drive maybe it's not even possible to do something like this? i thought i'd run it by people more familiar with vba. Thanks much in advance! . -- Cheers Andy http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|