Curve diagram

  • Thread starter Thread starter Snedker
  • Start date Start date
S

Snedker

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
 
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.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
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
 
Gromit.xl8z0 said:
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.
Click to expand...

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.]

--
Regards,

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