close

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

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:
gt; I've created 3 different line charts and am trying to combine them all into
gt; one chart with a different color for each line. Each line designates a
gt; different type of customer service. I can't figure out how to do it? Can
gt; anybody help?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()