+ Reply to Thread
Results 1 to 3 of 3

Excel charts. Is it possible to copy and pasta a data series quickly between charts?

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Excel charts. Is it possible to copy and pasta a data series quickly between charts?

    As in. I have one chart, and another chart. With different sets of data in them. And I want to copy 1 of those data lines to the other?
    Thanks so much

    David

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Excel charts. Is it possible to copy and pasta a data series quickly between charts?

    You would go to the actual data and copy the data, then select the chart and Paste Special.
    If the chart is selected, paste special will ask you if you want to add the data to an existing series or make a new series. You want to make a new series.

    Does that help?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Excel charts. Is it possible to copy and pasta a data series quickly between charts?

    Perfect thank you

+ 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. [SOLVED] Adding 1 series of data in 234 charts were 3 series already exist
    By Joachimjr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2014, 01:56 AM
  2. Replies: 0
    Last Post: 09-18-2013, 10:13 AM
  3. Formatting Data Series In Charts
    By eddiesvoicebox in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-21-2009, 01:28 AM
  4. Charts - Lining up one data series with another
    By whitespaces in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-03-2008, 06:28 AM
  5. Getting charts to automatically pick data from a series
    By Salmonh20 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2006, 02:45 PM
  6. quickly select data to produce charts
    By kim in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2006, 12:20 AM
  7. 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