#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 148
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   Report Post  
Posted to microsoft.public.excel.charting
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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cumulative Hours zephyr Excel Discussion (Misc queries) 0 November 8th 06 04:59 PM
How do I add Cumulative values to Stacked Bar chart? aspelker Charts and Charting in Excel 1 April 13th 06 01:02 PM
Cumulative Sum kk Excel Worksheet Functions 1 June 16th 05 09:02 AM
bar, line and cumulative bar graph in one chart Suchita Charts and Charting in Excel 2 January 14th 05 08:05 AM
Cumulative Total RockyMountains Excel Discussion (Misc queries) 9 January 12th 05 11:03 AM


All times are GMT +1. The time now is 01:05 PM.

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

About Us

"It's about Microsoft Excel"