sivaprakasam
Member
Hi
I am using the Excel 2013 and i am working in MIS Department
I have to change in select data the Specify Order For Series collection in Select Data for Chart
=SERIES([Series Name],[X Values],[Y Values],[Plot Order])
I have to change the "Holder" series collection from 5th to 1st move
I actually did something similar. I put "ActiveChart.SeriesCollection(5).PlotOrder = 1" for the first data series, but it doesn't work that way.
My VBA code not work, what i am wrong that i don't know....
enclosed the file and requirements as per the image
Kindly correction the VBA code
Thanks for Help....
I am using the Excel 2013 and i am working in MIS Department
I have to change in select data the Specify Order For Series collection in Select Data for Chart
=SERIES([Series Name],[X Values],[Y Values],[Plot Order])
I have to change the "Holder" series collection from 5th to 1st move
I actually did something similar. I put "ActiveChart.SeriesCollection(5).PlotOrder = 1" for the first data series, but it doesn't work that way.
My VBA code not work, what i am wrong that i don't know....
enclosed the file and requirements as per the image
Kindly correction the VBA code
Thanks for Help....