+ Reply to Thread
Results 1 to 2 of 2

How to create a scatter chart with two sets of data

  1. #1
    Registered User
    Join Date
    08-20-2014
    Location
    Rather not say
    MS-Off Ver
    10
    Posts
    3

    How to create a scatter chart with two sets of data

    Hello,

    I have two sets of data setup in the following way on an excel spreadsheet:

    I want to list both sets of data in one scatter chart with different colours for each area, however when I try this, excel creates two legends on the graph and relists each of the 3 areas. How can I stop it from doing this? Do I need to layout my data in a different way to achieve this?
    Attached Images Attached Images
    Last edited by dj322; 03-15-2021 at 11:33 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,291

    Re: How to create a scatter chart with two sets of data

    Not sure how you would the scatter chart to look, however here is an example of what could be made by changing the layout of the data.
    With columns set up for Date, Data Set, Area and Value a pivot table is produced.
    A line chart with markers is produced from the pivot chart and the fill for the lines is removed (options > format data series > line > no line is selected).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Create Scatter Chart with different color data points and Legend
    By marshak in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-14-2019, 11:28 AM
  2. Formatting multiple sets of data in scatter chart
    By RVA_ExcelMonkey in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-10-2015, 02:54 PM
  3. How to create show or hide the data series in Scatter Chart
    By anandltvs in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2015, 12:00 PM
  4. How to create show or hide the data series in Scatter Chart
    By anandltvs in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-26-2015, 10:50 AM
  5. Replies: 8
    Last Post: 10-31-2014, 04:34 PM
  6. Replies: 10
    Last Post: 07-21-2014, 11:11 AM
  7. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 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