Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: XY (Scatter) chart issues.

  1. #11
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Let's assume your dates are in column A starting in cell 1. In a free column, cell 1, put=YEAR(A1) and copy down the column.
    Use this column for your X axis and set major unit to 2 and minor unit to 1. This should give you what you want to do

  2. #12
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I must thank you for your help, We've been fighting with this for a while and with your suggestion it seems to all be fine now. We've changed the dates from 1/1/1979 to 1/5/1979 and then it will plot ok. When it gets to the problem years it will go to 1/4/1979.
    Thanks again!
    dan...

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Whoa!! Do I understand that all this time you're graphing only 1 value per year and that you're choosing an arbitrary date to represent each year? If that's the case an XY Chart isn't needed at all!!! It was my understanding that you had daily values that you wanted to plot on a X-axis with 2 year increments and still preserve the distribution (scatter) of the Y values. If that's not the case you should be using a Line chart (with the line attribute set to 'none') where the X-axis values are categories. Steve's recommendation of mapping daily values to a year value won't preserve the true distribution of daily values. The values will be "stacked" over each year label rather than scattered among the years.


    [ This Message was edited by: Mark W. on 2002-02-21 16:43 ]

  4. #14
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I agree that an XY scatter plot is not the best choice for this data, but at least there is a way to do what he wanted.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •