+ 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 2013
    Posts
    44

    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
    15,802

    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)

Similar Threads

  1. Display Chart up to current values
    By scruz9 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-30-2016, 12:21 AM
  2. Blank/NA values to be shown as dotted line rather than straight line in Charts
    By palaniappan0212 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2016, 01:01 AM
  3. [SOLVED] line chart, first few points no line shown
    By hluk in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-07-2014, 05:23 PM
  4. Chart with groups shown as line and not bar
    By etaf in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-16-2013, 02:27 PM
  5. Replies: 3
    Last Post: 04-07-2013, 07:40 AM
  6. Line Chart where two values are the same.
    By darbid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-25-2009, 12:49 PM
  7. [SOLVED] Line chart zero values
    By JC in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-08-2006, 09:00 PM

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