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