Results 1 to 1 of 1

Summing Chart

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-27-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    290

    Summing Chart

    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.
    Last edited by penfold1992; 10-04-2012 at 09:59 AM.

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