Re: Diagram with more than one curve

I would avoid the squiggly lines like the plague! I much prefer to choose
the straight lines so that I know where the real data points are (and I
choose whether or not I want individual points marked). I don't generally
allow Excel to guess at a curve between them. If the line between the
points is particularly questionable I will probably change it to dotted, or
remove the line altogether and just leave the points.
--
David Biddulph

"zitalen" <zitalen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:565CE6B9-230C-4D83-A9EC-6FD0C0BED11A@xxxxxxxxxxxxxxxx
Thank you!!! It works just as I wanted, except for the lines being too
squiggly (sp?), I have to adjust the values to make them smoother. It's
for a
first look where the customer chooses what unit too look more closely at.
I
have also managed to add a couple of more curves in my diagram. Thanks
again!
You made my day :)

Lena, Sweden

"David Biddulph" skrev:

I'm sorry that my Swedish would be much worse than your English.

I think the first problem is likely to be that you've got the wrong chart
type. In English, the type you need is labelled XY (Scatter), and on the
initial Chart Type menu it is shown as a scatter of dots, rather than
lines
(but having selected that, the sub-types allow you to include lines). I
think you have chosen Line Chart, which isn't what you need. In the
English
version, the order in which the Chart Types are listed is Column/ Bar/
Line/
Pie/ XY (Scatter)/ Area/ Doughnut/ Radar/ ..., so you need the 5th type,
not
the 3rd.

Try that, but you may then find that you have the X and Y in the wrong
order. By default, Excel will assume that the first column of data is
the X
axis, and the second column the Y. The easiest option may be to move or
copy your Capacity column to after your Sound pressure column, and then
select a data series which shows Sound Pressure in the first column and
Capacity in the second column, and hopefully Insert/ Chart will interpret
the data as you want it.
--
David Biddulph

"zitalen" <zitalen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6D8C98FD-AB1D-4608-9276-F5982C67BB9C@xxxxxxxxxxxxxxxx
I may be even more stupid than I thought.... I get a Y-axle with numbers
0
to
700 and an X-axle with numbers 1 to 13 (!) The 1 to 13 seems to be the
number
of data-entries I add to the diagram... I want the sound values (around
50-60
in value) to be the X-axle and the capacity to be the Y-axle (as it
is). I
get 2 curves (one for capacity and one for sound) instead of just one.
As
you
can see I am not at all ready to add data for the second curve...

I select the data for the first curve and choose the linear diagram no.
4
of
7 (it doesn't matter what kind of diagram I choose, I still get one
curve
for
capacity and one for sound). It's a bit hard to explain as my Excel is
in
Swedish.

"David Biddulph" skrev:

Yes, works fine for me.
Select the data (2 columns) for your first series, Insert/ Chart/ XY/
...
other options as appropriate.
Then Chart/ Source Data/ Add
X values for 2nd series
Y values for 2nd series
Names for series as appropriate.
--
David Biddulph

"zitalen" <zitalen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8E776C68-ACA9-4748-B3D5-55983980C238@xxxxxxxxxxxxxxxx
I am a bit stupid when it comes to Excel diagrams, so all your
answers
was
more than I understood. Here's what I want to do:

I want to create a diagram like this:
http://picasaweb.google.se/zitalena

Here are some of the values (the first 2 curves):

Capacity Sound pressure
178,5 56
206,3 56
240,9 58
278 58
308,1 59
369,9 59
420 60
480,1 60
482,3 61
556,9 61
549 61
648,4 61
616,2 62


149,5 49
169 49
200,3 51
230,4 51
255 53
303,8 53
349,5 53
395,6 53
400,6 54
460,2 54
476,4 55
535,5 55
509,9 56
607,6 56









.

Relevant Pages

  • Re: Diagram with more than one curve
    ... have also managed to add a couple of more curves in my diagram. ... I think the first problem is likely to be that you've got the wrong chart ... copy your Capacity column to after your Sound pressure column, ... Capacity in the second column, and hopefully Insert/ Chart will interpret ...
    (microsoft.public.excel.misc)
  • Re: Diagram with more than one curve
    ... I'm sorry that my Swedish would be much worse than your English. ... I think the first problem is likely to be that you've got the wrong chart ... copy your Capacity column to after your Sound pressure column, ... Capacity in the second column, and hopefully Insert/ Chart will interpret ...
    (microsoft.public.excel.misc)
  • Re: Differences in Aptitude
    ... the red curve means that the group of particular math capacity, ... Gauss curve, or some kind of probability distribution ... standard way of presenting experimental data. ... airhead. ...
    (soc.men)
  • Re: Differences in Aptitude
    ... reasons why women were and still are simply less capable on average. ... Higher meaning the size of the group, not capacity. ... That you do not know how to interpret a Gauss curve (a.k.a "normal ... Why bother living with a shrill mediocrity like Dowd really? ...
    (soc.men)
  • Gorilla Testing: Re: Differences in Aptitude
    ... the red curve means that the group of particular math capacity, ... Gauss curve, or some kind of probability distribution ... standard way of presenting experimental data. ...
    (soc.men)
Quantcast