Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Charts(Graphs) & Macros
I'm writring macros to create graphs & pivot tables, but every time I create
a graph, the lable name changes. Ie Chart1 to Chart2. Is there a way tohave a constant name for each graph???? |
#2
|
|||
|
|||
If you are making the gapohs onn their own sheets, They must have different
names. if not you can change the title inthe macro to what you want it to be. record a macro where you change the name of a chart tto find the format and in the main macro just rename the chart. "John" wrote: I'm writring macros to create graphs & pivot tables, but every time I create a graph, the lable name changes. Ie Chart1 to Chart2. Is there a way tohave a constant name for each graph???? |
#3
|
|||
|
|||
Thanks, but when I try to record a macro to re-name this, I don't know where
the "Chart1" is stored. If I record a macro to delete the chart anmd view this macro, The macro sees Chart1, but if I create again it will be Chart2?? "bj" wrote: If you are making the gapohs onn their own sheets, They must have different names. if not you can change the title inthe macro to what you want it to be. record a macro where you change the name of a chart tto find the format and in the main macro just rename the chart. "John" wrote: I'm writring macros to create graphs & pivot tables, but every time I create a graph, the lable name changes. Ie Chart1 to Chart2. Is there a way tohave a constant name for each graph???? |
#4
|
|||
|
|||
the initial names for the charts are going to increrment by one each time a
new chart is added, even if ther previous charts on that sheet are deleted. this would be ithe index number of that chart. You can either refer to a chart by an index or a name Chartobjects(1) would always refer to the first chart generated on any given worksheet. "John" wrote: Thanks, but when I try to record a macro to re-name this, I don't know where the "Chart1" is stored. If I record a macro to delete the chart anmd view this macro, The macro sees Chart1, but if I create again it will be Chart2?? "bj" wrote: If you are making the gapohs onn their own sheets, They must have different names. if not you can change the title inthe macro to what you want it to be. record a macro where you change the name of a chart tto find the format and in the main macro just rename the chart. "John" wrote: I'm writring macros to create graphs & pivot tables, but every time I create a graph, the lable name changes. Ie Chart1 to Chart2. Is there a way tohave a constant name for each graph???? |
#5
|
|||
|
|||
Chart Names:
http://peltiertech.com/Excel/ChartsH...ameAChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bj wrote: the initial names for the charts are going to increrment by one each time a new chart is added, even if ther previous charts on that sheet are deleted. this would be ithe index number of that chart. You can either refer to a chart by an index or a name Chartobjects(1) would always refer to the first chart generated on any given worksheet. "John" wrote: Thanks, but when I try to record a macro to re-name this, I don't know where the "Chart1" is stored. If I record a macro to delete the chart anmd view this macro, The macro sees Chart1, but if I create again it will be Chart2?? "bj" wrote: If you are making the gapohs onn their own sheets, They must have different names. if not you can change the title inthe macro to what you want it to be. record a macro where you change the name of a chart tto find the format and in the main macro just rename the chart. "John" wrote: I'm writring macros to create graphs & pivot tables, but every time I create a graph, the lable name changes. Ie Chart1 to Chart2. Is there a way tohave a constant name for each graph???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Executing of excel Macros. | Excel Discussion (Misc queries) | |||
help with excel (maybe macros) | Excel Worksheet Functions | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
how can i edit excel 4 macros in Excel 2003 | Excel Worksheet Functions |