+ Reply to Thread
Results 1 to 3 of 3

Time Series Data Curve appear off on the graph

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2010
    Posts
    15

    Time Series Data Curve appear off on the graph

    I created a simple graph with the following time series data:

    Group 1
    A B
    Q1-2018 3.77 43.1
    Q2-2018 2.83 43.1
    Q3-2018 3.16 41.1
    Q4-2018 3.22 39
    Q1-2018 3.67 39.1
    Q2-2018 2.81 39
    Q3-2018 3.14 38.8
    Q4-2018 3.14 37.6
    Q1-2018 3.67 38.8

    Unfortunately, the curve for column B is a bit off. The data points on the curve look higher than their actual values as shown on the following screen shot:


    Excel_graph_chart.jpg

    I tried adjusting the scale but the data points still look off. Looking for a solution so any assistance would be greatly appreciated for this issue. Thanks.

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

    Re: Time Series Data Curve appear off on the graph

    What chart type are you using (and did you intend to use)? The B line looks about right for a stacked line chart, so I would guess that you are using a stacked line chart. Did you intend to use a stacked line chart, or were you intending to use a regular line chart?
    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-25-2013
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2010
    Posts
    15
    Quote Originally Posted by MrShorty View Post
    What chart type are you using (and did you intend to use)? The B line looks about right for a stacked line chart, so I would guess that you are using a stacked line chart. Did you intend to use a stacked line chart, or were you intending to use a regular line chart?
    You’re right. For some reason, it defaulted to a stacked chart instead of a regular line chart. Problem solved. 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. For multiple time series, graph from starting value and not from zero
    By amoore5000 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-03-2016, 04:47 PM
  2. Graph a curve, then enter data to generate new similar curve
    By denphi03 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 11-03-2013, 05:33 PM
  3. Excel VBA Time Series Graph
    By dsom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 03:08 AM
  4. line graph with multiple data series vs. time/date leaves out most data
    By Lee Collins in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2012, 10:54 AM
  5. how to make time series graph?
    By SanjayKumar14 in forum Excel General
    Replies: 2
    Last Post: 12-25-2011, 07:47 PM
  6. Time Series Graph
    By bucksbengalstrojans in forum Excel General
    Replies: 2
    Last Post: 08-10-2011, 04:16 AM
  7. Time Series Graph to Movie Clip
    By dudekid in forum Excel General
    Replies: 1
    Last Post: 10-06-2009, 05:46 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