A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cumulative Chart?



 
 
Thread Tools Display Modes
  #1  
Old August 15th, 2007, 10:56 PM posted to microsoft.public.excel.charting
Heather
external usenet poster
 
Posts: 360
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!
  #2  
Old August 16th, 2007, 02:00 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
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!



 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.