+ Reply to Thread
Results 1 to 3 of 3

Help needed with chart with multiple series

  1. #1
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Question Help needed with chart with multiple series

    Hello,

    I have the following data sample:

    01/01/2019 | AB123 | 100
    14/02/2019 | AB123 | 124
    16/02/2019 | AB123 | 124
    16/02/2019 | AB123 | 127
    10/02/2019 | AC221 | 103
    16/04/2019 | AC221 | 121
    21/05/2019 | AC221 | 128

    Is it possible for me to get this data on a chart in the following way:

    Criteria 1 (dates) as the horizontal axis
    Criteria 2 (eg AB123) as the series (one series for each criteria code)
    Criteria 3 (numbers) as the data in the body of the chart

    Any help would be appreciated!

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

    Re: Help needed with chart with multiple series

    Simplest way is with a pivot chart. Assuming you want the values for a criteria on the same day accumulated.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Re: Help needed with chart with multiple series

    Thanks Andy, that's what I was after. Have a good one

+ 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: 2
    Last Post: 02-19-2017, 07:52 PM
  2. Replies: 1
    Last Post: 06-18-2015, 02:01 PM
  3. [SOLVED] Drag & Drop Chart Series Points At Run Time (Help Needed From Excel VBA Gurus)
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2015, 07:08 AM
  4. River Cross Section Chart - Area Chart Multiple series
    By ppdominic in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2014, 06:01 AM
  5. Replies: 2
    Last Post: 03-05-2013, 03:07 PM
  6. [SOLVED] Stacked area chart with one negative data series needed to be shown separately
    By Ivkosky in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-11-2012, 03:50 AM
  7. Macro needed for multiple series of data to plot unique charts
    By ehelliar in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 04-23-2011, 11:50 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