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
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" <[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
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks