+ Reply to Thread
Results 1 to 2 of 2

How to merge series with identical names on line graph? Excel 2007.

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    Toronto, Canada
    MS-Off Ver
    2007
    Posts
    1

    How to merge series with identical names on line graph? Excel 2007.

    How can I merge series that have identical names on a line graph?
    Ex.
    ABC:5
    BBC:4
    CBC:3
    ABC:10
    DBC:5

    Currently the line graph just makes two sets for "ABC". How can I make it one?

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How to merge series with identical names on line graph? Excel 2007.

    You need a macro to merge the data on the worksheet table...How it will work exactly depends on your data layout and the specific series names but it's fairly simple.
    Elegant Simplicity............. Not Always

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

    Re: How to merge series with identical names on line graph? Excel 2007.

    formula or pivot table are other ways to create a summary data set for you chart.

    Charts by themselves do no summarize data.
    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. Excel 2007 : Graph named series not copying with sheet
    By sweep in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-07-2014, 08:02 AM
  2. Excel 2007 Line Graph Help please.
    By trevordsmith in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-04-2013, 02:39 AM
  3. Excel 2007 : find & replace for graph series
    By roland willems in forum Excel General
    Replies: 7
    Last Post: 02-28-2013, 03:38 PM
  4. Difficulty adding a trend line to line graph in Excel 2007
    By jmatoske in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-28-2012, 02:59 PM
  5. Line Graph in Excel 2007
    By vandammelieven in forum Excel General
    Replies: 8
    Last Post: 02-14-2011, 06:29 AM

Tags for this Thread

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