Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
This has to be easy.
I need to create a BLANK chart using VBA and rename it.
I am using Charts.Add The problem i keep running into is that when i create a new chart, it increments chart1 then chart2, etc... even if i rename the new chart I am creating a module to be used in MSAccess to automate excel, so i will not have the luxury of knowing what the new chart name will be. It would be great if i could do something like VariableNewChartName = Charts.Add Sheets(VariableNewChartName ).Name = VariableMyNewName or something like that |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
This has to be easy.
Got it:
Dim Chrt As Chart Set Chrt = Charts.Add With Chrt .Name = "freddykruger" End With "PK" wrote: I need to create a BLANK chart using VBA and rename it. I am using Charts.Add The problem i keep running into is that when i create a new chart, it increments chart1 then chart2, etc... even if i rename the new chart I am creating a module to be used in MSAccess to automate excel, so i will not have the luxury of knowing what the new chart name will be. It would be great if i could do something like VariableNewChartName = Charts.Add Sheets(VariableNewChartName ).Name = VariableMyNewName or something like that |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
This has to be easy.
Or simply:
Charts.Add.Name = "My New Chart" - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PK" wrote in message ... Got it: Dim Chrt As Chart Set Chrt = Charts.Add With Chrt .Name = "freddykruger" End With "PK" wrote: I need to create a BLANK chart using VBA and rename it. I am using Charts.Add The problem i keep running into is that when i create a new chart, it increments chart1 then chart2, etc... even if i rename the new chart I am creating a module to be used in MSAccess to automate excel, so i will not have the luxury of knowing what the new chart name will be. It would be great if i could do something like VariableNewChartName = Charts.Add Sheets(VariableNewChartName ).Name = VariableMyNewName or something like that |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy one....Right? | Excel Discussion (Misc queries) | |||
How to sum in an easy way? | Excel Discussion (Misc queries) | |||
This should be easy | Excel Worksheet Functions | |||
Here's an EASY one for you, not me :( | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel |