4 Replies Latest reply on Nov 11, 2012 12:10 PM by Stephen Bone

# How do I create two line charts on one worksheet using two sets of measures?  I feel this is easy but I'm having brainfreeze.  In other words, one chart, two lines on the same chart representing groups of two measures....

How do I create two line charts on one worksheet using two sets of measures?  I feel this is easy but I'm having brainfreeze.  In other words, one chart, two lines on the same chart representing groups of two measures....

• ###### 1. Re: How do I create two line charts on one worksheet using two sets of measures?  I feel this is easy but I'm having brainfreeze.  In other words, one chart, two lines on the same chart representing groups of two measures....

Hi Stephen, your question isn't completely clear. Also it would be very helpful if you read these Guidelines and then reposted your question with a sample workbook. Thanks,

--Shawn

• ###### 2. Re: How do I create two line charts on one worksheet using two sets of measures?  I feel this is easy but I'm having brainfreeze.  In other words, one chart, two lines on the same chart representing groups of two measures....

Why, thank you Shawn.  If you read the above then you would see that if I could provide an example then I would've already answered my question.  I CAN'T provide an example....therefore the question.  However, the question is fairly straightforward.  I need to produce a worksheet with one graph.  It needs to contain two lines of 7 common measures each.  I've seen graphs with two lines, or bars and a line on the chart.  How do you produce that worksheet with two lines showing two measures on one chart?

• ###### 3. Re: How do I create two line charts on one worksheet using two sets of measures?  I feel this is easy but I'm having brainfreeze.  In other words, one chart, two lines on the same chart representing groups of two measures....

Hi Stephen,

There are various ways to do this, but they depend on how they underlying data is organized. That's why Shawn asked for a workbook with some sample data. For example, if you have your data set up with a different column for each measure, then you can use Measure Values as the "measure" and then put Measure Names on the Color Shelf, and you will end up with a line for each measure, as in the attached. However, as I'd noted, if your data is organized differently than another method may be required.

Jonathan

• ###### 4. Re: How do I create two line charts on one worksheet using two sets of measures?  I feel this is easy but I'm having brainfreeze.  In other words, one chart, two lines on the same chart representing groups of two measures....

Thanks Jonathan, I get it put that way and know exactly what to do...thanks!  And sorry to Shawn, I was way over deadline and if you remember that line from "Network" (in the 80's or 90's):  "I'm mad as H___ and I'm not gonna take it any more!".  Thanks again-