+ Reply to Thread
Results 1 to 5 of 5

Data line is incorrect when there is two lines of data

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    Wichita, KS
    MS-Off Ver
    Excel 2007
    Posts
    1

    Data line is incorrect when there is two lines of data

    Hello,

    I am trying to create a simple data chart with 2 axis lines. The first line in the data is correct, but when I add the 2nd line it is posting off by around 2000. It shows the correct data when you click show data, but is not on the correct axis line on the chart.

    I have attempted to add a picture of the issue.

    KanBama

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,692

    Re: Data line is incorrect when there is two lines of data

    Hi
    there is no picture attached, coud you try again - better still, upload a spreadsheet if it has no confidential information

  3. #3
    Registered User
    Join Date
    11-30-2011
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Data line is incorrect when there is two lines of data

    Hi KanBama,

    sounds like you are using chart type 'stacked lines' rather than a regular line chart.

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Data line is incorrect when there is two lines of data

    KanBama, it's hard to tell what you want to do. What do you mean with "axis lines"? Are you creating a line chart with two data series? Is the X axis a category axis? Maybe you need to use an XY chart instead of a line chart.

    Post a sample file with some dummy data that illustrates your issue. Then we will be able to give more detailed advice.

    cheers,

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,828

    Re: Data line is incorrect when there is two lines of data

    Perhaps you are using a stacked line chart
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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