+ Reply to Thread
Results 1 to 3 of 3

Line Graph Problem

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    8

    Line Graph Problem

    So, I have three time series that look like this
    A B C
    Jan 10 100 300
    Feb 20 120 310
    Mar 15 130 295
    Apr 30 200 400

    etc.
    obviously when i try to plot the data to a line graph with only 1 Y-axis, the A series look flat down under. (something like this http://officeimg.vo.msecnd.net/en-us...A010227707.gif)
    I then try to separate them into 2 graph "A vs B" and "A vs C" and with 2 Y-axis, but this still doesn't work, what the "A vs B" graph show is both line start and end at similar location, despite that over the course of the period A has tripled while B has only doubled.
    Is there a graph that allows me to compare these series?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Line Graph Problem

    Building a chart with multiple series where the series are on dramatically different scales is always difficult. You might consider a panel chart like this: http://peltiertech.com/Excel/ChartsH...venScales.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    10-28-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Line Graph Problem

    thanks for the reply, but this look so complicated that I might just do add a multiplier to the series to make them comparable..... Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help with a basic line graph problem
    By Meeraan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-04-2013, 01:38 AM
  2. Problem with line graph template
    By Beginner Level in forum Excel General
    Replies: 2
    Last Post: 02-14-2012, 09:54 PM
  3. line graph problem in excel!!!
    By mstehman88 in forum Excel General
    Replies: 2
    Last Post: 09-04-2011, 06:54 AM
  4. Line Graph problem
    By jsmity in forum Excel General
    Replies: 4
    Last Post: 11-06-2009, 10:50 AM
  5. [SOLVED] Line Graph Problem
    By Nick I in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-06-2005, 10:05 AM

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.6.0 RC 1