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
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
    ... 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 ... I select the data for the first curve and choose the linear diagram no. ...
    (microsoft.public.excel.misc)
  • 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: run time 1004: the method applycustomtype for object _chart
    ... If he doesn't mind having the chart names on his machine in English instead of German, you could just copy a version of the English "Xl8garly.xls" file over his German version... ... Or he just opens up his German chart gallery file and renames the chart type concerned so that it matches the English name. ... Dim FirstMonth, LastMonth As Range ...
    (microsoft.public.excel.programming)
  • Re: OWC 11 Unspecified Error 0x80004005
    ... the code is not correct to load the chart, have a look at one of the ... examples provided on the office website ... > Windows 2000 Sp4 English ... > //fileXmlName is a XmlFile generated by record set ...
    (microsoft.public.office.developer.web.components)
  • Re: some more Irish vowels
    ... English many times. ... beloved IPA chart? ... Wedge does not represent a mid low back unrounded vowel. ...
    (sci.lang)