Solved Two Series represented with Single line in Excel Chart/Graph

Microsoft Office 2007 professional (aca...
November 1, 2013 at 04:01:25
Specs: Windows XP, 256 mb
I want to make a chart in which Two series are represented by single line. EG my data set is

X Min Max

A 5 9
B 10 15
C 6 8

is it possible to make a chart wof these values with single line joining all points?

Thanks in Adv.

See More: Two Series represented with Single line in Excel Chart/Graph

Report •

November 1, 2013 at 05:58:50
✔ Best Answer
First, a posting tip: Before posting example data in this forum, please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Thanks!

As for your question, it's not really clear to me what you are trying to do. If you want all 6 (?) pieces of data represented on one line, what order are you looking for?

For example, let's say you start with this:

      A     B      C
1     X    Min    Max
2     A     5      9
3     B    10     15
4     C     6      8

Do you want the data graphed as:

5, 10, 6, 9, 15, 8


5, 9, 10, 15, 6 ,8

or something else?

In any case, while I am not a charting expert, I don't think you can create a single line directly from data in 2 columns. One possible work around is to "duplicate" your data via formulas. Refering to the data above, set up a range similar to this:

      A     B      C      D
1     X    Min    Max   Points  
2     A     5      9     =B2
3     B    10     15     =B3
4     C     6      8     =B4
5                        =C2
6                        =C3
7                        =C4

If you graph D1:D7, you should have a graph that shows 5, 10, 6, 9,15, 8 on a single line, in that order.

Does that help?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

November 22, 2013 at 03:36:15
Thanx for your reply

Actually i want to learn how to make S curve in excel

Report •

Related Solutions

Ask Question