Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro creates two graphs instead of one?
Hi,
I used the macro recorder to record all the steps that I took to create a graph. However, when I try to run the macro, it creates two versions of the graph that I want - putting them in as Chart1 and Chart 2 (or whatever else the numbers happen to be) in my workbook. Chart1 is usually the chart that I want, which has a title and data table, and Chart2 is the same chart but without the title and data table. I only want Chart1. Any thoughts on why Excel is doing this? FYI, I am creating a bar graph, and the macro is supposed to define chart title and put in the data table under the graph. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro creates two graphs instead of one?
I suspect you have included code that creates the additional (could have been
a mistake when you were recording). Perhaps it creates the one with missing elements, then copies it and adds the elements. If so, you would need to remove the lines that do this. -- Regards, Tom Ogilvy "et10yl" wrote: Hi, I used the macro recorder to record all the steps that I took to create a graph. However, when I try to run the macro, it creates two versions of the graph that I want - putting them in as Chart1 and Chart 2 (or whatever else the numbers happen to be) in my workbook. Chart1 is usually the chart that I want, which has a title and data table, and Chart2 is the same chart but without the title and data table. I only want Chart1. Any thoughts on why Excel is doing this? FYI, I am creating a bar graph, and the macro is supposed to define chart title and put in the data table under the graph. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code, My excel macro creates the charts on top of each other | Excel Programming | |||
Macro creates additional datafiles when saving copies of workbook | Excel Programming | |||
selecting variable rows in a macro that creates a pivot table | Excel Programming | |||
How to Rename a Blank Sheet that a macro Creates | Excel Programming | |||
Macro that creates a directory but... | Excel Programming |