+ Reply to Thread
Results 1 to 2 of 2

Both line showing same trend instead which is wrong

  1. #1
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Both line showing same trend instead which is wrong

    My graph is showing the same trend of the two values even actually both trends are different.


    further if i switch to the date and time instead of number the graph is not correct

    looking for the help of the experts (excel file attached)

    thanks in advance

    Azam
    Attached Files Attached Files
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,893

    Re: Both line showing same trend instead which is wrong

    Fist of all, you have stacked line chart selected as chart type.

    Change chart type to "Line chart".

    Second, if you want to use datetime as x-axis.

    Go to axis option and set custom number format and display number as one of accepted datetime format.
    Ex: "mm-dd-yy h:mm:ss"
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. Trend line & data points over wrong bar charts
    By vemix in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-17-2016, 12:26 PM
  2. Trend lines gone wrong
    By rob3_142 in forum Excel General
    Replies: 2
    Last Post: 10-09-2015, 12:22 PM
  3. Replies: 5
    Last Post: 10-12-2014, 04:26 PM
  4. Difficulty adding a trend line to line graph in Excel 2007
    By jmatoske in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-28-2012, 02:59 PM
  5. Replies: 2
    Last Post: 11-18-2012, 11:20 AM
  6. Excel calculating totally wrong trend line equations
    By exclnoob in forum Excel General
    Replies: 7
    Last Post: 09-27-2012, 06:22 AM
  7. Line Graph showing wrong data
    By kevin2184 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-01-2011, 10:59 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