PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Cumulative Chart?
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Cumulative Chart?
![]() |
Cumulative Chart? |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
I'm curious if there is a way to display my data in a cumulative form in an
excel chart? Here's an example of data Baseline Jan 21 Feb 14 Mar 31 Apr 08 Type1 50 5 -3 4 2 Type2 29 4 -2 4 3 Type3 81 9 -8 2 8 I know that I could do this my creating another set of data that adds the column together and just do a regular chart, but was hoping that someone might know of a way to skip this intermediate step? Thanks! |
|
|
|
#2 |
|
Guest
Posts: n/a
|
The chart needs to plot existing data. Put it in another column (as you
already know how to do) and plot the calculated column. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Heather" <Heather@discussions.microsoft.com> wrote in message news:0EDD9EA2-7127-4872-BE52-8AFD05E27827@microsoft.com... > I'm curious if there is a way to display my data in a cumulative form in > an > excel chart? > Here's an example of data > Baseline Jan 21 Feb 14 Mar 31 Apr 08 > Type1 50 5 -3 4 2 > Type2 29 4 -2 4 3 > Type3 81 9 -8 2 8 > > I know that I could do this my creating another set of data that adds the > column together and just do a regular chart, but was hoping that someone > might know of a way to skip this intermediate step? > > Thanks! |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

