+ Reply to Thread
Results 1 to 2 of 2

Help needed to create a scatter chart

  1. #1
    Registered User
    Join Date
    06-25-2019
    Location
    London
    MS-Off Ver
    10
    Posts
    1

    Help needed to create a scatter chart

    I have been trying to find a way of plotting data into a scatter chart whereby the X/horizontal axis is day of the week "Mon, Tue, Wed, Thu, Fri" and the Y/vertical axis is a +/- percent change.

    The aim of what I 'm trying to achieve is to have a visual representation of each day of the week showing the %change variation.

    I have a attached a sample of the data I have for reference.

    Thanks in advance to anyone that can help.
    Attached Files Attached Files

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

    Re: Help needed to create a scatter chart

    Why not use a line chart with markers and simple format the line to be no line.

    If you want to have different horizontal spacing between Friday and Monday's, i.e. including weekends, then use actual dates and format to display day only. Format horizontal axis to be Date.
    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. [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. 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
  3. 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
  4. Macro to automatically create scatter chart
    By jpxexcelforum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2014, 10:23 PM
  5. Create a scatter chart to show a correlation between two variables
    By Blake 7 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-10-2012, 02:10 AM
  6. Create a Combined Chart for Stacked Area and Scatter
    By PosseJohn in forum Excel General
    Replies: 2
    Last Post: 11-29-2010, 12:53 PM
  7. Replies: 6
    Last Post: 11-11-2010, 02:20 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