Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Pat B
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using drop lines with XY scatter chart SMACS03 Charts and Charting in Excel 1 February 8th 06 03:47 AM
Horizontal lines in waterfall chart Tim Charts and Charting in Excel 1 October 9th 05 11:45 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Leader Lines Connecting Chart to Box TOMB Excel Discussion (Misc queries) 1 May 7th 05 06:02 PM
How can I show data under a Chart that I inserted in a worksheet? Kimo Charts and Charting in Excel 1 February 21st 05 04:11 PM


All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"