ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How Can I show 3 different lines in one chart? (https://www.excelbanter.com/charts-charting-excel/70224-how-can-i-show-3-different-lines-one-chart.html)

Pat B

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

Andy Pope

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


All times are GMT +1. The time now is 08:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com