I want to create a graph that adds the last value onto the previous value, is this possible?
I currently have a line graph in which i would like to view the difference between the two lines however the scale is sometimes so small that the values are barely noticable.
so my plan is to add the previous value onto the next which will eventually make the graph display the difference at the end sort of looking like this:
| /
| /
| _____/ ________/
|/ _______/
|__/
|___________________
one solution would be to create a new column with cells that have formulas such as:
=0.5 +B2
=0.3 +C2
=0.4 +D2
but im wondering if there is an option to do this without having to create another couple of columns.
Edit: sorry the ASCII representation didnt work as planned.
Bookmarks