Edit chart seriescollection within a "With" - "End With" Block

Hello.
In Excel Worksheet I need to edit a Chart (seriescollection values and format.fill
I got a code with the macro recorder on. For me such codes are confusing.
I need to modify the following codes to look for efficiency.

Here my codes:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

How can I write these codes lines within a "With" "End With Code?
Also, how can I write

Please Login or Register  to view this content.

As VBA:

Please Login or Register  to view this content.

If this is correct.

I hope some else can help me.
Cheers

I really appreciate your reply.

I wrote the first code as:

Please Login or Register  to view this content.

VBA displays 'Error 438 Object does not support this property or method' here:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA displays 'Error 438 Object does not support this property or method' here:

Please Login or Register  to view this content.

I am trying to write codes inside a With End With Block.
Moreover, I tried to declare variables such as.

Please Login or Register  to view this content.

I spent hour and hours googling and I did not find similar code examples.

Any help is really welcome

Cheers

Hello.
Yes, I tested your code. Works well.
I really apologize. First, I just to write my messages in NotePad. I think my previous post was a problem of copy and paste.

Only the second code displays "Runtime Error 91: Object variable or with block variable not set"

Please Login or Register  to view this content.

I have been trying to fix it, but error still ocurred.

Cheers

Hello. Thanks

To test both codes I used F8.
First I ran the first code that works perfectly.
Then, I ran the second code and "Runtime Error 91: Object variable or with block variable not set"

Cheers

AlphaFrog

I did a few changes to your codes and now all three are working well:

First code:

Please Login or Register  to view this content.

Second code

Please Login or Register  to view this content.

Third code

Please Login or Register  to view this content.

Can you tell if there is a way to simplify the three codes into one code?
Is possible to simplify the codes using variables? If true, How can I add variables?
Is it true that from 2010 "fullseriescolletion" should be written as "seriecolletion"?

I really appreciate your help

Cheers

AplphaFrog.
Your codes work fine.
I still don't know the use of Exclamation Mark (!) in the code.
Thank you for your help.