Chart Problems with Recorded Macros

[ceecld]

I have used a macro that plot graphs from masses of data then formats the graphs for going straight into reports. When i recorded the macros i plotted the graphs in a particualr order, therefore if i run the macros in another order it doesnt work since the chart numbers are wrong. see code below:


ActiveChart.HasLegend = False
ActiveSheet.Shapes("Chart 2").IncrementLeft 137.25

What i dont understand is why it cant just use the activeChart function for the incrementleft function, rather than activesheet which requires a chart name - e.g. Chart 2 meaning that my graphs have to be plotted in a specific order.

Thanks


Chris Dall

 

[SkipVought]

Chris Dall,

When you run

ActiveChart.HasLegend = False
ActiveSheet.Shapes("Chart 2").IncrementLeft 137.25

do all the OTHER charts already exist on the sheet?

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[ceecld]

it depends if you have selected to plot them already, i want to give the user the option of what information the plot rather than having to plot 25 graphs just so you can get the last one in the list.

hope that makes sense

 

[SkipVought]

Well if you just add the 25th chart on your list, unless you NAMED the chart, Chart 25, it's Chart 1 or Activesheet.Shapes(1)

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[ceecld]

if i made all my plots activesheet.shapes(1) then surely thats not going to work as they will all be called the same thing.

Also the chart wasn't specificaly named excel just labeled them in the order they were created.

 

[ceecld]

Basically what im wanting to do is use the ACTIVE chart at that point in time. not a named or otherwise chart

 

[SkipVought]

???

if i made all my plots activesheet.shapes(1) then surely thats not going to work ...

YOU have not control over this. The first chart that is placed on a sheet is NUMBER ONE in the shapes collection.

If you have more than one chart on the sheet, for instance two, then you have Activesheet.Shapes(1) and Activesheet.Shapes(2)

What's the process here?

Does the user select which chart to plot? If so, then you KNOW which one is on the sheet each time another one is added, right?

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[GlennUK]

How about:

ActiveSheet.Shapes(ActiveChart.Parent.Name).IncrementLeft 137.25

Glenn.

 

[ceecld]

Thanks GlennUK that was exactly what i was looking for!

Thanks!