+ Reply to Thread
Results 1 to 7 of 7

XY Scatter graph issues

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    71

    Question XY Scatter graph issues

    Hi excel gurus,

    I am trying to create a scatter graph on excel 2010 and these are the issues I am facing:

    (1) Data labels - For the data labels I can use http://www.appspro.com/Utilities/ChartLabeler.htm however, I donít have administrative rights on my school's laptop and require an alternative option

    (2) Data layout Ė I know that I will need helper columns to create the output I am trying to achieve. I am having difficulty creating these helper columns.

    (3) X Axis how do I get the days on the x axis?


    I have hand drawn the graphic output (sorry I am not a good drawer) I want to achieve using a sample set of data (both files are attached below).

    your help is appreciated!
    Attached Images Attached Images
    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,114

    Re: XY Scatter graph issues

    Given you x axis is categorical rather than value you can get away with using a line chart.

    add a column before and after data and then set axis to cross on Tick marks. "NotUsed" text is a place holder so you can see whats happening.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: XY Scatter graph issues

    Thank you Andy!

  4. #4
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: XY Scatter graph issues

    Andy I was successfully able to create a chart using your example, however, I have one little problem
    I have a lot of data points between 12 - 3 AM and it's making the data labels difficult to read.. is there a way to increase the space in the y axis?
    you can also refer to the picture to understand my question better. aa.PNG

  5. #5
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: XY Scatter graph issues

    http://www.excelforum.com/excel-prog...ta-labels.html

    Also posted under macros to see if a hide macro can be created... I am open to new suggestions as well. Thanks!

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

    Re: XY Scatter graph issues

    If you have space at the top and or bottom of the chart then you can expand the data area by changing the Min and Max values of the vertical scale.

    Code for toggling data labels.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: XY Scatter graph issues

    Thanks for your help Andy, really appreciate it!

+ 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. Scatter Graph
    By mma3824 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-26-2014, 04:21 AM
  2. Scatter Graph to show data along side scatter points
    By jonathan.haynes in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-15-2013, 08:59 AM
  3. Scatter Graph
    By thebestrc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-28-2008, 06:16 AM
  4. 3D scatter graph i.e X, Y, Z, scatter graph
    By SuperNomad in forum Excel General
    Replies: 3
    Last Post: 03-27-2007, 03:06 PM
  5. [SOLVED] scatter graph
    By pathologist in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-30-2005, 10:06 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