+ Reply to Thread
Results 1 to 4 of 4

Adding 1 series of data in 234 charts were 3 series already exist

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    72

    Adding 1 series of data in 234 charts were 3 series already exist

    Hello,

    Is there any smarter way than adding 1 more series manually to every chart? The range of the column is consistant to every 5th column.

    Thanks in advance,
    Joachim

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,868

    Re: Adding 1 series of data in 234 charts were 3 series already exist

    Only smarter way is with VBA code.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,665

    Re: Adding 1 series of data in 234 charts were 3 series already exist

    You probably shall prepare VBA macro to do this. Unfortunalely you posted no sample file, so have a look on a dummy attached.
    I made some 4 graphs there, then registered a simple macro while adding a new series to a one graph.
    Please Login or Register  to view this content.
    Then I deleted this newly added series from the graph. And to a code of macro added a loop going through all ChartObjects in the worksheet. It looks now:
    Please Login or Register  to view this content.
    Run it and you will see the result - similar method can probably be applied to your workbook.
    Of course the code could be more developed etc. But already such simple one shall do what was described above.
    Attached Files Attached Files
    Last edited by Kaper; 07-09-2014 at 10:27 AM.
    Best Regards,

    Kaper

  4. #4
    Registered User
    Join Date
    06-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    2010
    Posts
    72

    Re: Adding 1 series of data in 234 charts were 3 series already exist

    Thank you very much Kaper!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stock charts - adding extra data series
    By alexisjohansen in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-24-2014, 12:24 PM
  2. =SERIES and charts (adding two cells in a series formula)
    By benmmaddog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2013, 09:52 PM
  3. Formatting Data Series In Charts
    By eddiesvoicebox in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-21-2009, 01:28 AM
  4. Stock charts - adding extra data series
    By steven723 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2008, 05:58 PM
  5. How can you add the same data series to all charts in a workbook
    By MBubier in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-30-2006, 10:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1