# Plot a line graph showing the diference between two columns

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. ## 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,

##### Users Browsing this Thread

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

#### 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