mixed plot: scatter, vertical, and horizontal lines

[confused_newbie]

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

 

[Guest]

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

 

[Jon Peltier]

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

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

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

 

[fernando cinquegrani]

"Bob Umlas, Excel MVP" <[email protected]> ha
scritto nel messaggio

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

 

[KR]

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!