Auto create series & namnig

[Majid2009]

I need to get a macro that will auto plot number of series and name them according to a value.

The attached file has an example, I have highlighted column H (x-axis) & K (y-axis) and the name of the series should be from column B. Each series has to end at the begining of the other series. The graph there is what I want to get.

This is only example, I have over 20 series to be plotted!

Thanks in advace

[Andy Pope]

Try this

Please Login or Register  to view this content.

[Majid2009]

Andy Pope;

This is really great, it is working very nice, many thanks.

Yours;
Majid

[Majid2009]

Andy;

Is it possible to modify the codes so that it will ask the user to chose the x & y axis to be plotted?

Thanks in advance.

Yours;
Majid

[Andy Pope]

If you are going to allow the user to select columns for x and y values you propbably do not want to restrict axis max and min.

Please Login or Register  to view this content.

[Majid2009]

Andy;

You are great man, Thanks alot.