Split Excel Line Graph

I

Iola

New Member
Joined
Jan 13, 2009
Messages
4
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!
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
Thanks, but to which of the links in that section should I refer? I don't see how to do this.
 
Upvote 0
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
 
Last edited:
Upvote 0
excel_graph.gif


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.
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Excel spreadsheet - online as a interactive website - what to do next
Replies
1
Views
113
Rijnsent
Rijnsent
C
  • Solved
Comparing 2 worksheets with different rows with conditions
Replies
9
Views
110
Country_Calc_2
C
J
  • Question
Graph Gridlines and Axis Ranges Help
Replies
1
Views
72
awoohaw
awoohaw
R
  • Question
Line Graph
Replies
1
Views
246
awoohaw
awoohaw
C
  • Question
Filter using subtotal or countif question
Replies
1
Views
208
arthurbr
arthurbr

Forum statistics

Threads
1,214,822
Messages
6,121,772
Members
449,049
Latest member
greyangel23

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top