+ Reply to Thread
Results 1 to 2 of 2

Problem with current values and forecasted values to be shown in the same line chart

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    36

    Problem with current values and forecasted values to be shown in the same line chart

    Hi all,

    I have difficulties to represent in the same line chart current and future values. I have attached a file with the initial table.

    As you can see I have values for nine different months, which are the current ones. Then, I have forecasted those values in two different ways. Lag1 is forecasted one month later and Lag2 is forecasted two month later.
    I have tried to plot that in a line chart with three lines (Actual, Lag1 and Lag2), but I have not been successful.

    I guess I need to change the structure of the data?

    Any help will be really appreciated.

    Thanks in advance.
    Attached Files Attached Files

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

    Re: Problem with current values and forecasted values to be shown in the same line chart

    I don't understand what you are trying to do on the Result tab.

    As a guess, I selected B2:E10 on the InitialTable tab, and inserted a regular line chart based on this table. For once, Excel correctly guessed that I wanted A2:B10 as the X axis data and C2:E10 as the three series (if your version of Excel does not guess this correctly, then go into the Select Data dialog and make these corrections). Is there any chance that is what you are looking for?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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