macro converting graphs into jpeg files

[makinmomb]

I want to convert graphs which are on excel into a folder named say graphs on drive c

I am completely blank to macros , but I can run macros when given spoon feeding

[MickG]

This code will export your current sheet chart to a "jpg" file (Temp)with the same path as your parent file.
Nb:- Change Path Name, Sheet name & Chart Name, to suit

Please Login or Register  to view this content.

Regards Mick

[makinmomb]

Yes it does exactly what i need , but it throws only one graph , I have quite a few too on one sheet

[MickG]

You will probably need to loop through the chart collection Like:-
To create individual files for each chart.

Please Login or Register  to view this content.

Or even:-

Please Login or Register  to view this content.

Regards Mick