Thread: 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

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
>
>
>

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
>>
>>
>>

"Bob Umlas, Excel MVP" <BobUmlasExcelMVP@discussions.microsoft.com> ha
scritto nel messaggio
news:7216AE4D-DF39-45F4-8261-BC98FECE1E56@microsoft.com...
> 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

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" <nospam@columbus.rr.com> wrote in message
news:%23O8c8D5cFHA.3932@TK2MSFTNGP12.phx.gbl...
> 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
>
>