
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....
Shawn Wallwork Nov 10, 2012 3:40 PM (in response to Stephen Bone)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....
Stephen Bone Nov 10, 2012 4:58 PM (in response to Shawn Wallwork)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....
Jonathan Drummey Nov 11, 2012 11:50 AM (in response to Stephen Bone)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....
Stephen Bone Nov 11, 2012 12:10 PM (in response to Jonathan Drummey)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