Curve diagram

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Snedker - 27 Nov 2003 10:05 GMT

I'm hoping to find some help in here:

I'm trying to make a diagram showing to rows of data. However, I wish
the two rows to be handled as one row. The two rows give me two curves
in the diagram, but I only wish one.

A look at http://dbconsult.dk/test/xr.jpg shows what I mean. I shows
to groups of numbers, what with measures with even numbers and one
with uneven numbers. I wish to create the upper diagram (/x values).

Also: is it possible in the diagram with a dotted line to show maximum
and minimum value of the data?

Thx in advance

/Snedker

Reply to this Message

Tushar Mehta - 27 Nov 2003 15:11 GMT

The only way I can think of is to merge the two data sets together. It
*might* be possible to do so with a formula, but in any case, you would
have to merge the data sets.

As far as drawing the horizontal lines goes, see the Excel | Charts |
'Straight Lines' page of my web site.

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> I'm hoping to find some help in here:
>
[quoted text clipped - 12 lines]
>
> /Snedker

Reply to this Message

Gromit - 28 Nov 2003 05:10 GMT

Hi,

I think I understand what you need - maybe easiest to explain b
example, which you can adapt to your needs.

Suppose you have two rows of data, A1:C1 and A2:C2. Highlight the rang
A1:C2 and hit the chart wizard and select a line chart: you end up wit
chart of two lines, each of three points.

Click on the blue line (the first series) and look in the formula bar
you'll see this:

=SERIES(,,Sheet1!$A$1:$C$1,1)

Replace this with the following line:

=SERIES(,,(Sheet1!$A$1:$C$1,Sheet1!$A$2:$C$2),1)

And there you have a single line of six points.

HTH,

Graha

Reply to this Message

Tushar Mehta - 28 Nov 2003 11:01 GMT

> Replace this with the following line:
>
> =SERIES(,,(Sheet1!$A$1:$C$1,Sheet1!$A$2:$C$2),1)
>
> And there you have a single line of six points.

No, if I understand correctly, the OP doesn't want A1:C1 then A2:C2.
The OP wants A1, A2, B1, B2, C1, C2... with the distinct possibility
that the data are not in adjacent rows.

[Posted directly to the Usenet newsgroup -- no affiliation with Excel
Forum.]

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Hi,
>
[quoted text clipped - 21 lines]
>
> ------------------------------------------------

Reply to this Message