Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Axis Title
Hello, I am trying to find a way, to change Axis titles via VBA. But I
can only select those. Can anybody help? Thanks in advance, Oliver |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Axis Title
This is in VBA help files:
For the X axis: With Charts("Chart1").Axes(xlCategory) .HasTitle = True .AxisTitle.Text = "July Sales" End With For the Y axis change xlCategory to xlValue, and of course, the title. " wrote: Hello, I am trying to find a way, to change Axis titles via VBA. But I can only select those. Can anybody help? Thanks in advance, Oliver |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Axis Title
On Jan 7, 4:42*pm, JLGWhiz wrote:
This is inVBAhelp files: For the Xaxis: With Charts("Chart1").Axes(xlCategory) * * .HasTitle = True * * .AxisTitle.Text = "July Sales" End With For the YaxischangexlCategory to xlValue, and of course, thetitle. " wrote: Hello, I am trying to find a way, tochangeAxistitles viaVBA. But I can only select those. Can anybody help? Thanks in advance, Oliver- Hide quoted text - - Show quoted text - Thanks, that worked, Oliver |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Axis title | Charts and Charting in Excel | |||
I cannot enlarge the axis title box, the cursor won't change | Charts and Charting in Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
How do I change the size of Value Axis Title box for an Excel Cha. | Charts and Charting in Excel | |||
Y-axis title | Charts and Charting in Excel |