+ Reply to Thread
Results 1 to 5 of 5

mixed plot: scatter, vertical, and horizontal lines

  1. #1
    confused_newbie
    Guest

    mixed plot: scatter, vertical, and horizontal lines

    What would be the best way to create/construct a scatterplot diagram that
    also had some (data-based, not drawn-in) horizontal _and_ some vertical
    lines in it?

    Thanks!
    Keith



  2. #2
    Bob Umlas, Excel MVP
    Guest

    RE: mixed plot: scatter, vertical, and horizontal lines

    use an xy scatter, for the vertical lines you can copy them, then click onthe
    chart and use edit/paste special; select new series, and categories are in
    the first column, then when this is pasted in, format it to have no markers
    but does have a line. Same with Horizontal line (another new series.)

    "confused_newbie" wrote:

    > What would be the best way to create/construct a scatterplot diagram that
    > also had some (data-based, not drawn-in) horizontal _and_ some vertical
    > lines in it?
    >
    > Thanks!
    > Keith
    >
    >
    >


  3. #3
    Jon Peltier
    Guest

    Re: mixed plot: scatter, vertical, and horizontal lines

    As an alternative, you could use error bars for the horizontal and
    vertical lines:

    http://peltiertech.com/Excel/Charts/...Gridlines.html
    http://peltiertech.com/Excel/Charts/AddLine.html

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


    Bob Umlas, Excel MVP wrote:

    > use an xy scatter, for the vertical lines you can copy them, then click onthe
    > chart and use edit/paste special; select new series, and categories are in
    > the first column, then when this is pasted in, format it to have no markers
    > but does have a line. Same with Horizontal line (another new series.)
    >
    > "confused_newbie" wrote:
    >
    >
    >>What would be the best way to create/construct a scatterplot diagram that
    >>also had some (data-based, not drawn-in) horizontal _and_ some vertical
    >>lines in it?
    >>
    >>Thanks!
    >>Keith
    >>
    >>
    >>


  4. #4
    fernando cinquegrani
    Guest

    Re: mixed plot: scatter, vertical, and horizontal lines


    "Bob Umlas, Excel MVP" <[email protected]> ha
    scritto nel messaggio
    news:[email protected]...
    > use an xy scatter, for the vertical lines you can copy them, then
    > click onthe
    > chart and use edit/paste special; select new series, and categories
    > are in
    > the first column, then when this is pasted in, format it to have no
    > markers
    > but does have a line. Same with Horizontal line (another new series.)


    samples:
    http://www.prodomosua.it/zips/linee.xls
    .f



  5. #5
    KR
    Guest

    Re: mixed plot: scatter, vertical, and horizontal lines from OP

    Thanks to all for your replies. I had some trouble with pasting new series
    (edit/paste special disabled for scatterplots in XL2003/ Win2000 when
    pasting series data?) but the use of error bars worked great- I started with
    a multi-series line graph and then changes one to the scatterplot source
    data and type, and used both secondary axes. Thanks to all for your help and
    suggestions!

    "confused_newbie" <[email protected]> wrote in message
    news:%[email protected]...
    > What would be the best way to create/construct a scatterplot diagram that
    > also had some (data-based, not drawn-in) horizontal _and_ some vertical
    > lines in it?
    >
    > Thanks!
    > Keith
    >
    >




+ 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