If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How Can I show 3 different lines in one chart?
I've created 3 different line charts and am trying to combine them all into
one chart with a different color for each line. Each line designates a different type of customer service. I can't figure out how to do it? Can anybody help? -- B''''''''''''''''s mom |
#2
|
|||
|
|||
How Can I show 3 different lines in one chart?
Hi,
Select one of your existing charts. Right click and pick Source Data from the popup menu. On the Series tab use the Add button to add another series to the chart. Then go to the Values box and define the range for the data. Repeat for the 3rd series. I have assumed the category labels, or x axis, are consistent across all 3 lines. Cheers Andy Pat B wrote: I've created 3 different line charts and am trying to combine them all into one chart with a different color for each line. Each line designates a different type of customer service. I can't figure out how to do it? Can anybody help? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Play with lines in one chart | pacific | Charts and Charting | 5 | August 27th, 2008 02:44 PM |
mix chart types | Ken Murray | Powerpoint | 7 | April 28th, 2006 02:50 AM |
Chart doesn't show in Word | Ki | Charts and Charting | 2 | February 8th, 2006 11:55 PM |
Show value in Data Table but not on live chart | Gonepostal | Charts and Charting | 1 | January 17th, 2006 12:23 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |