Split Excel Line Graph

[Iola]

I am trying to present data from 2 clients side by side in a line graph. Here's the graph set-up:

Legend: Scale 1, Scale 2
X Axis: Client (1, 2, & 3), and Measurement (1, 2, &3).

I would like to present client 1, time 1, 2, and 3 for each scale first, then the same for the second and third clients.

I am able to create this graph, but I don't know how to break the lines for each scale by client. So, I don't want Scale 1 to be one continuous line, but 3 lines -- 1 for each client.

Is this possible?

Thank you!

 

[nbrcrunch]

Scroll down to "Charts and Graphing in Excel"

http://www.mrexcel.com/articles.shtml

 

[Iola]

Thanks, but to which of the links in that section should I refer? I don't see how to do this.

 

[nbrcrunch]

in the simplest of charts, you would grab starting from left upper corner of data grid to the bottom right corner, including headings and record/row identifiers.

Say for example you had months as heading labels and salesmen's names as row names, the cross of any two points being the sales figures for that month & person. You would take all that and then launch the chart wizard.

post what your data looks like by using http://www.excel-jeanie-html.de/index.php?f=1

 

[Iola]

Here is a picture of the graph as it is. I'm trying to get the lines to break at each new client. What I mean is, I don't want the "Intensity Scale" line for Client 1 to be connected to the "Intensity Scale" line for Client 2 - I would like three graphs side by side in one image.

 

[Sal Paradise]

I think this link is what you want. It covers the whole gamut.

Essentially, you need to offset your data (or stagger it) so that the series don't connect when you plot it.

 

[Iola]

That's EXACTLY what I wanted! Thank you!

 

[Sal Paradise]

Thank Jon Peltier. That entire site, and Andy Pope's site (www.andypope.info) are the best resources I've found so far for charting things that look nice and communicate effectively.