auto charts with single data

[orajesh]

Greetings,

Please find attached one sample excel file I am attaching herewith. I have a data set as shown in sheet1. My requirement is to create multiple charts as shown in Chart sheets ( TYPE1, TYPE 2 and TYPE3) at one single shot through macro or any other means.

Regards
Rajesh

[NickyC]

Hi try this macro
you may need to adjust the source range if you have more rows than in your workbook

Please Login or Register  to view this content.

[orajesh]

Greetings,

Thank you for your effort. While running error is coming in the line

ActiveChart.FullSeriesCollection(1).XValues = XRange


it says

"compile Error, Method or Data Member Not found"

Regards
Rajesh

[NickyC]

Hi
that probably means it is not recognising XRange as a range
did you set a valid range for XRange - eg C1:J1 in your original sheet?
also, does it include a valid sheet name?

[orajesh]

Hi.. Greetings,

I worked with the same file which I had sent. Again I enclosing the raw file with macro ..

Thanks

[NickyC]

Hi
the macro worked fine on your sheet when I ran it. A bit of googling found other users with this problem. Does this solve it?

https://www.mrexcel.com/forum/excel-...not-found.html

alternatively, try changing the problem line to :

Please Login or Register  to view this content.

and see if that works

[orajesh]

Sorry, checked and the problem still not solved.

Regards
Rajesh

[NickyC]

sorry Rajesh I ran it again, and again it worked fine for me. Can you check that all the sheet names, variable names and ranges and range names are correct?

https://msdn.microsoft.com/VBA/Langu...ound-error-461

if so, I don't think I can help you. It may be an issue with your computer.

[orajesh]

Thanks Nicky for your trial. May be some version/ my system issues.
Regards
Rajesh