Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Selected Chart
I am trying to write a VBA code that will take the selected Pie chart and
modify the size of the chart and the plot area. This is my first venture into VBA and I'm not having much luck. Was wondering if someone could point me in the right direction. Using Excel 2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Selected Chart
Record a macro while you perform the actions you need, then punch up the
macro. See also: http://peltiertech.com/Excel/Charts/chartvba.html http://peltiertech.com/WordPress/200...our-own-macro/ http://peltiertech.com/WordPress/200...ecorded-macro/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John" wrote in message ... I am trying to write a VBA code that will take the selected Pie chart and modify the size of the chart and the plot area. This is my first venture into VBA and I'm not having much luck. Was wondering if someone could point me in the right direction. Using Excel 2003 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Selected Chart
Thanks! Lots of good info here.
Question, how to you reference the selected chart? In most examples dealing with this subject you need to reference the charts name. When I first tried to create a macro that resized the chart, it keeps trying to resize the same chart. I want it to resize the chart I have selected when I run the macro. Any ideas? "Jon Peltier" wrote: Record a macro while you perform the actions you need, then punch up the macro. See also: http://peltiertech.com/Excel/Charts/chartvba.html http://peltiertech.com/WordPress/200...our-own-macro/ http://peltiertech.com/WordPress/200...ecorded-macro/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John" wrote in message ... I am trying to write a VBA code that will take the selected Pie chart and modify the size of the chart and the plot area. This is my first venture into VBA and I'm not having much luck. Was wondering if someone could point me in the right direction. Using Excel 2003 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Selected Chart
ActiveChart
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John" wrote in message ... Thanks! Lots of good info here. Question, how to you reference the selected chart? In most examples dealing with this subject you need to reference the charts name. When I first tried to create a macro that resized the chart, it keeps trying to resize the same chart. I want it to resize the chart I have selected when I run the macro. Any ideas? "Jon Peltier" wrote: Record a macro while you perform the actions you need, then punch up the macro. See also: http://peltiertech.com/Excel/Charts/chartvba.html http://peltiertech.com/WordPress/200...our-own-macro/ http://peltiertech.com/WordPress/200...ecorded-macro/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John" wrote in message ... I am trying to write a VBA code that will take the selected Pie chart and modify the size of the chart and the plot area. This is my first venture into VBA and I'm not having much luck. Was wondering if someone could point me in the right direction. Using Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In VBA, how do you format selected code all at once? | Excel Discussion (Misc queries) | |||
Chart is shaded when not selected | Charts and Charting in Excel | |||
object selected on a chart | Excel Programming | |||
Can you select a chart but not see it's selected? | Charts and Charting in Excel | |||
Determining if a chart is selected | Charts and Charting in Excel |