+ Reply to Thread
Results 1 to 2 of 2

Copying Chart and pasting down multiple lines but series not changing - help

  1. #1
    Registered User
    Join Date
    03-03-2015
    Location
    Baltimore, Maryland
    MS-Off Ver
    2010
    Posts
    6

    Angry Copying Chart and pasting down multiple lines but series not changing - help

    Hi I will try to explain this as best as I possibly can. I have a huge table of Compensation Statement Data, Each Row data is entered for a new employee. In Column DN I am trying to insert a chart. I am selecting the series data by highlighting DB2 and DC2 hitting insert then bar graph, 100% Stacked bar. The information in DB2 is Total ER Paid Insurance Benefit and the information in DC2 is Total EE Paid Insurance Benefit. I can format the graph to fit in cell DN. When I copy the graph down (my data is entered until line 105) the Series data in the chart remains ='Benefit Data Sheet Edit'!$DB$2:$DC$2

    If I edit the graph in DN2 series data to ='Benefit Data Sheet Edit'!DB2:DC2 and copy and paste down, the $$ come back.

    Can I copy and paste this graph and have the data change to pull from the correct line? (aka next line down).

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

    Re: Copying Chart and pasting down multiple lines but series not changing - help

    Charts don't update data references like that when using copy/paste.
    You would need code to speed up the process.

    If you are doing a sparkline style of chart for each data row you might consider 'in cell' charts.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 10
    Last Post: 10-14-2013, 05:28 AM
  2. [SOLVED] Macro for Copying and pasting from one excel workbook into a series of other workbooks
    By Smeddlesboy in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-09-2013, 02:12 PM
  3. All the series lines in the chart are drawn on the same line
    By JMicke in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-13-2012, 07:15 AM
  4. Series/lines invisible on chart
    By gnoke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2010, 08:26 AM
  5. Copying and pasting a series of cells
    By MattBeckwith in forum Excel General
    Replies: 3
    Last Post: 02-12-2006, 11:10 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