View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Cumulative Chart?

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" wrote in message
...
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!