+ Reply to Thread
Results 1 to 3 of 3

2 timelines in 1 graph, messed up axis

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    17

    2 timelines in 1 graph, messed up axis

    Hi,

    I'm very confused why I'm having this trouble. I've just made a simple comparison between the growth of money supply and inflation in Sweden and the inflation line in my graph doesn't look anything like it should according to the data. If I the Inflation line to be on the secondary axis it all works fine but I really want to know why I'm having this trouble when I have them on the same axis, and how to solve it without changing to secondary axis.

    Here's the file:M3 och KPI 1982-2012.xlsx


    I'm using Excel for mac 2011.

    Thanks!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,631

    Re: 2 timelines in 1 graph, messed up axis

    Hi, You made this graph as type "cumulative linear" (may be the name is slightly different in your version of excel). Use just "linear with markers".
    See attached corrected one.
    Attached Images Attached Images
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: 2 timelines in 1 graph, messed up axis

    Ah! How simple. For some reason I'd chosen the wrong kind of graph! 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. Replies: 4
    Last Post: 05-17-2012, 11:25 AM
  2. Replies: 0
    Last Post: 06-13-2011, 11:11 AM
  3. Replies: 0
    Last Post: 06-27-2007, 02:33 PM
  4. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 PM
  5. [SOLVED] why is the y-axis label in the Excel graph always messed up?
    By Song in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-02-2005, 12:06 AM

Tags for this Thread

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