Add New Series To Charts

  • Hi Guys,
    I have a problem with this code, i am trying to add 50 new data series and it takes hell of a lot of time to do it manually. can any one please advise ...



  • Re: Add New Series To Charts


    Just a thought...you're telling the code to loop until 'total' is less than 100 yet it starts out being less than 100 so wouldn't that mean it's done?


    Maybe something more like this:

  • Re: Add New Series To Charts


    Hi,


    I think that Total in speech marks is causing a problem. This seems to work, although it creates a new chart rather than amends an old one.


  • Re: Add New Series To Charts


    I've amend the spreadsheet so that it works but it is too big to upload.


    Here is the code.



    You need to change a couple of things.


    Change the location of the chart to be a chart and call it Chart1
    Get rid of the total at the bottom of the data as it gets entered as a series. Amend the forumulas in column I to divide by SUM($F$£:$F$63)


    Any problems, send me your email address and I'll mail the file

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!