|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
Re: mixed plot: scatter, vertical, and horizontal lines
"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 |
|
#5
|
|||
|
|||
|
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" <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 > > |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|