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" wrote in message
...
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" wrote in message
...
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