+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Pat B
    Guest

    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. #2
    Andy Pope
    Guest

    Re: 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 Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0