Adjusting Series Formats in VBA

[ParkerExcel]

I have a lot of data that I need to graphically represent. I have three near identical (but not) graphs on every worksheet in my workbook. I've used VBA to generate the graphs, but what I'd like to do is
1.) Specify where the graphs are located
2.) Adjust the color of the data series from one graph to the next.

I can't use the Macro recorder because it gives me code that fails everytime I try to use it. Does anybody know how to do this? Thanks!

I've attached a sample of where I want the charts to be and what I want the series to look like. The Macro for generating the charts is in the workbook.

[ParkerExcel]

Okay I managed to find a code that specified series color.

Please Login or Register  to view this content.

So all I need is a way to locate the chart