# 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
 HiI want to make a chart in which Two series are represented by single line. EG my data set isX Min MaxA 5 9B 10 15C 6 8is 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

#1
November 1, 2013 at 05:58:50
 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 or 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?