PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Cumulative Chart?

Reply

Cumulative Chart?

 
Thread Tools Rate Thread
Old 15-08-2007, 10:56 PM   #1
=?Utf-8?B?SGVhdGhlcg==?=
Guest
 
Posts: n/a
Default Cumulative Chart?


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!
  Reply With Quote
Old 16-08-2007, 02:00 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: 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" <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!



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off