| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relocate Value Axis Title
I an having issues with the value axis title appearing in different locations
depending on jow many data series are in a chart. I have tried a few things, most recently the following line of code: ActiveChart.Axes(xlValue).AxisTitle.Left = ActiveChart.PlotArea.Left + 10 It works about 90% of the time. When I increased the number of data series to seven, the title is back inside the plot area. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Relocate Value Axis Title
What version of Excel?
On occasion with chart VBA, it helps to run the command twice, that's right, copy the line and paste it right after itself, so it executes twice. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chip" wrote in message ... I an having issues with the value axis title appearing in different locations depending on jow many data series are in a chart. I have tried a few things, most recently the following line of code: ActiveChart.Axes(xlValue).AxisTitle.Left = ActiveChart.PlotArea.Left + 10 It works about 90% of the time. When I increased the number of data series to seven, the title is back inside the plot area. Any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Relocate Value Axis Title
Thanks, Jon.
I am using XP, my client has 2003. I'll try out your suggestion. Great website, by the way! "Jon Peltier" wrote: What version of Excel? On occasion with chart VBA, it helps to run the command twice, that's right, copy the line and paste it right after itself, so it executes twice. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chip" wrote in message ... I an having issues with the value axis title appearing in different locations depending on jow many data series are in a chart. I have tried a few things, most recently the following line of code: ActiveChart.Axes(xlValue).AxisTitle.Left = ActiveChart.PlotArea.Left + 10 It works about 90% of the time. When I increased the number of data series to seven, the title is back inside the plot area. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Axis title | Charts and Charting in Excel | |||
| Axis title | Charts and Charting in Excel | |||
| Axis title | Charts and Charting in Excel | |||
| Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
| Y-axis title | Charts and Charting in Excel | |||
Hybrid Mode
