+ Reply to Thread
Results 1 to 2 of 2

Plot a line graph showing the diference between two columns

  1. #1
    Registered User
    Join Date
    02-18-2012
    Location
    Belize
    MS-Off Ver
    Excel 2010
    Posts
    1

    Plot a line graph showing the diference between two columns

    I want to plot a simple line graph that shows the difference (x values) between two cells in two seperate columns A2 and A3 , without calculating and pasting the diference in a seperate column A4, against a time line A1 (Y values). So basically that is Plotting X vs Y without having the A4 column. Any help would be appreciated
    For Example
    A1 A2 A3 A4
    Y X
    01:00 AM 5 9 4
    12:00 PM 3 6 3
    06:00 PM 8 2 -6

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

    Re: Plot a line graph showing the diference between two columns

    Hello,

    you can create a named range with the formula

    =Sheet1!$C$2:$C$4-Sheet1!$B$2:$B$4

    Then create an XY chart and enter this as the series formula.

    =SERIES("data",Sheet1!$A$2:$A$4,YourFileName!YValues,1)

    Replace "YourFileName" with the name of your file.

    cheers,

+ 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