Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
link chart axis title to cell?
Alternatively, remove ".Characters" and change to R1C1 notation:
.Axes(xlValue, xlPrimary).AxisTitle.Text = "=Sheet1!R24C5" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris" wrote in message ... Thanks a lot Martin "Martin" wrote: VBA is a very different place to Excel and it has to talk a kind of pidgin-English to be understood by Excel! Instead of Sheet1!E24 which is pure Exceleeze you've got to say: ActiveWorkbook.Sheets("Sheet1").Range("E24").Value It's logical but kinda laborious... "Chris" wrote: When running a macro, how do I link a chart axis title such as the y-axis to a cell in a worksheet? In the VBA section, the line of code for the title is: .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Values" I'm trying to link the word "Values" to a cell instead of a text string. I tried typing in Sheet1!E24 with and without quotes but it won't work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link chart axis scale to spreadsheet cell value | New Users to Excel | |||
Chart Axis Title via cell ref. | Charts and Charting in Excel | |||
Chart Y-Axis Title | Charts and Charting in Excel | |||
How to link a chart title to a worksheet cell c#? | Excel Programming | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |