+ Reply to Thread
Results 1 to 5 of 5

Duplicating Chart to Next Row of Data

  1. #1
    Registered User
    Join Date
    12-18-2015
    Location
    Minnesota
    MS-Off Ver
    2007
    Posts
    15

    Duplicating Chart to Next Row of Data

    I have a fairly complex chart with 10 different series based off of one row of data. I want to duplicate the chart I made so that it will automatically populate using the next row of data without me having to Select Data and change the source for each series. I have a lot of rows that each need their own chart (like 40, so that 40 rows x 10 series = 400 changes &#128556, looking for a quick way...

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

    Re: Duplicating Chart to Next Row of Data

    You could use VBA to edit the Formula property of each Series
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-18-2015
    Location
    Minnesota
    MS-Off Ver
    2007
    Posts
    15

    Re: Duplicating Chart to Next Row of Data

    Andy, I'm not a VBA user would need more info.

  4. #4
    Registered User
    Join Date
    12-18-2015
    Location
    Minnesota
    MS-Off Ver
    2007
    Posts
    15

    Re: Duplicating Chart to Next Row of Data

    Andy,
    I'm not a VBA user, would need more info.

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

    Re: Duplicating Chart to Next Row of Data

    the code would be something like this

    Please Login or Register  to view this content.
    although it would need to loop through series and charts.
    The replacement of row number may need to be more complex to avoid replacing only part of the row number.

    But it hard to tell as I don't know what your chart setup is.
    Attached Files Attached Files

+ 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. Duplicating chart format over multiple group of data
    By chlronald in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-11-2020, 06:53 PM
  2. [SOLVED] Pivot Chart is duplicating certain values that I add to the Axis Fields List, why?
    By seanpod in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 09-13-2017, 10:19 AM
  3. Help, Duplicating a sheet with duplicating ability
    By joseph_pat in forum Excel General
    Replies: 7
    Last Post: 06-26-2015, 07:55 AM
  4. duplicating Data Macro
    By arcolombo698 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 01:49 PM
  5. Duplicating Data
    By Overzero in forum Excel General
    Replies: 4
    Last Post: 05-04-2011, 11:56 PM
  6. Excel 2007 : duplicating data
    By lesray in forum Excel General
    Replies: 5
    Last Post: 01-28-2011, 05:03 PM
  7. Duplicating the exact same chart
    By 8dee in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-04-2009, 10:51 PM

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