+ Reply to Thread
Results 1 to 5 of 5

scatter plot question

  1. #1
    AS
    Guest

    scatter plot question

    I have office 2003. I am using xy scatter plot with sub type data points
    connected by smoothed lines. My problem is the point that should be the
    highest in the graph is actually not. The line always ascend alittle higher
    next to the highest dadum point and then descend. How do you fix this?
    thanks!

  2. #2
    Jon Peltier
    Guest

    Re: scatter plot question

    Fix it by not using the smoothing option on the lines. The smoothing is an
    artificial fitting, not reflecting the actual data, but only looking pretty.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______


    "AS" <AS@discussions.microsoft.com> wrote in message
    news:2B706EFE-D4FD-4D6A-B7BF-21DDE2D5BCE9@microsoft.com...
    >I have office 2003. I am using xy scatter plot with sub type data points
    > connected by smoothed lines. My problem is the point that should be the
    > highest in the graph is actually not. The line always ascend alittle
    > higher
    > next to the highest dadum point and then descend. How do you fix this?
    > thanks!




  3. #3
    AS
    Guest

    Re: scatter plot question

    But I need to use smooth graph because it looks better, and are there any
    ways? thanks.

    "Jon Peltier" wrote:

    > Fix it by not using the smoothing option on the lines. The smoothing is an
    > artificial fitting, not reflecting the actual data, but only looking pretty.
    >
    > - Jon
    > -------
    > Jon Peltier, Microsoft Excel MVP
    > Tutorials and Custom Solutions
    > http://PeltierTech.com
    > _______
    >
    >
    > "AS" <AS@discussions.microsoft.com> wrote in message
    > news:2B706EFE-D4FD-4D6A-B7BF-21DDE2D5BCE9@microsoft.com...
    > >I have office 2003. I am using xy scatter plot with sub type data points
    > > connected by smoothed lines. My problem is the point that should be the
    > > highest in the graph is actually not. The line always ascend alittle
    > > higher
    > > next to the highest dadum point and then descend. How do you fix this?
    > > thanks!

    >
    >
    >


  4. #4
    David Biddulph
    Guest

    Re: scatter plot question

    "AS" <AS@discussions.microsoft.com> wrote in message
    news:0FC061ED-B4CB-4B5F-95FC-B841576F9822@microsoft.com...
    > "Jon Peltier" wrote:


    >> "AS" <AS@discussions.microsoft.com> wrote in message
    >> news:2B706EFE-D4FD-4D6A-B7BF-21DDE2D5BCE9@microsoft.com...
    >> >I have office 2003. I am using xy scatter plot with sub type data
    >> >points
    >> > connected by smoothed lines. My problem is the point that should be
    >> > the
    >> > highest in the graph is actually not. The line always ascend alittle
    >> > higher
    >> > next to the highest dadum point and then descend. How do you fix this?
    >> > thanks!


    >> Fix it by not using the smoothing option on the lines. The smoothing is
    >> an
    >> artificial fitting, not reflecting the actual data, but only looking
    >> pretty.


    > But I need to use smooth graph because it looks better, and are there any
    > ways? thanks.


    If you insist on using smoothed lines and you don't like Excel's algorithm,
    you could always generate your own smoothing algorithm, imposing whichever
    constraints you wish to apply. The other point if you must insist on using
    smoothed lines is to make sure you plot the points themselves, rather than
    just the lines between (and preferably make the line dotted to show how
    imaginary it is).
    --
    David Biddulph



  5. #5
    Jon Peltier
    Guest

    Re: scatter plot question

    It looks prettier because it misrepresents your data, which is what prompted
    you to start this thread.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______

    "AS" <AS@discussions.microsoft.com> wrote in message
    news:0FC061ED-B4CB-4B5F-95FC-B841576F9822@microsoft.com...
    > But I need to use smooth graph because it looks better, and are there any
    > ways? thanks.
    >
    > "Jon Peltier" wrote:
    >
    >> Fix it by not using the smoothing option on the lines. The smoothing is
    >> an
    >> artificial fitting, not reflecting the actual data, but only looking
    >> pretty.
    >>
    >> - Jon
    >> -------
    >> Jon Peltier, Microsoft Excel MVP
    >> Tutorials and Custom Solutions
    >> http://PeltierTech.com
    >> _______
    >>
    >>
    >> "AS" <AS@discussions.microsoft.com> wrote in message
    >> news:2B706EFE-D4FD-4D6A-B7BF-21DDE2D5BCE9@microsoft.com...
    >> >I have office 2003. I am using xy scatter plot with sub type data
    >> >points
    >> > connected by smoothed lines. My problem is the point that should be
    >> > the
    >> > highest in the graph is actually not. The line always ascend alittle
    >> > higher
    >> > next to the highest dadum point and then descend. How do you fix this?
    >> > thanks!

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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