VBA

[BaGRoS]

Hi

I never used VBA for Excel before.

Why this command give error, second one also, but If I uncomment "On Error..." second one fill chart as should be.

Sorry for picture, not source. I used this at work, now I'm at home...

Any advice?

Many thanks,

BaGRoS

 

[Micron]

Chart code isn't my area of expertise but I'll guess it's because you don't activate the chart first.

Chart.SetElement method (Excel)

Office VBA reference topic

learn.microsoft.com

Resume Next will cause errors to be ignored and code will just continue to run. It's not suitable for most cases and I'd say this ins one of those.

 

[BaGRoS]

I add .Activate

    With Sheets("Graph_Template")
    .Activate

but still have error on:

and

and

Even with the errors, everything seems to be working... It shows the error, and populates the table with the correct values...
Which is weird, but good for me :P

Many thanks,
BaGRoS

 

[Micron]

You're activating a sheet, they activated a chart?

This example sets chart elements by using the various constant values to an active chart.

 

[BaGRoS]

Set objChrt = .ChartObjects("Chart 6")
        objChrt.Activate
        Set chrt = objChrt.Chart

The problem is only with the bottom chart:

and way if this

chrt.SetSourceData (Sheets(SheetName).Range(StartVal_X & ":" & EndVal_X))

gives me an error, it still fills in this chart??!!

 

[Micron]

I don't know enough about this to offer an explanation. Sorry, best I could do is point you to the link after doing some research.