VBA Chart fill area

[grymloc04]

I am trying to automate the changing of my chart fill area. I was hoping someone could help me write some VBA code to do this. I have an example excel worksheet that I can show what I am looking for but I have no way of finding the code behind the chart. Any help would greatly be appreciated. Thank you.

[IBihy]

Hi,

how about attaching that worksheet?

Regards,
Isabella

[grymloc04]

I tried posting the worksheet but the file size is too large for me to post. Is there an e-mail I could send it to for you to look at? Thank you for helping.

[mancubus]

you may reduce the file size by deleting unnecessary data, fortmats, etc, then winzip or winrar, etc, and upload.

[grymloc04]

Here is the first of the four zip files. I had to change the other three names. So, please just change the daily donut mess up 1 to have a file extension of .z01 and then the same for daily donut mess up 2 => .z02 and then 3 => .z03 and the file should extract. Thank you for any support.

[grymloc04]

here is the .z01 file.

[grymloc04]

Here is the .z02 file.

[grymloc04]

here is the final .z03 file. Thank you again for any help provided.

[grymloc04]

One last thing. I am trying to change the pictures from the "racey" women to something more appropriate. I would like to use my collection of airplane pictures instead.