Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 35
Default How do I create a "cumulative" chart in Excell, which ADDS #'s ?

I simply want to create a chart which ADDS each numerical value to the one
preceeding it, resulting in a graph which, by definition, keeps increasing in
value....rather than one which goes up and down to reflect each individual
value entered.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default How do I create a "cumulative" chart in Excell, which ADDS #'s ?

Hi,

This is not a charting issue, instead you need to set up your data area to
handle this and then chart that. For example if you have your numeric values
in cells B10:M10, then in B11 enter the formula =B10+A10 (where nothing is
in cell A10) and copy it across to column M. Then chart this row of data
rather than row 10.
--
Cheers,
Shane Devenshire


"Jimbo" wrote:

I simply want to create a chart which ADDS each numerical value to the one
preceeding it, resulting in a graph which, by definition, keeps increasing in
value....rather than one which goes up and down to reflect each individual
value entered.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,118
Default How do I create a "cumulative" chart in Excell, which ADDS #'s ?

Since what you're describing is a feature of a Pareto Chart....

Perhaps the Pareto Plotter at this website will help:
http://www.contextures.com/excelfilesRon.html

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Jimbo" wrote in message
...
I simply want to create a chart which ADDS each numerical value to the one
preceeding it, resulting in a graph which, by definition, keeps increasing
in
value....rather than one which goes up and down to reflect each individual
value entered.



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
How to create a scatter chart with 2 "X" values with common "Y"s M_LeDuc Charts and Charting in Excel 2 September 13th 07 10:26 PM
Why does excell switch my stock symbol "ACN" to "CAN"? garron Setting up and Configuration of Excel 1 June 21st 07 02:35 AM
Excel adds a "1" to filenames opened from desktop shortcut skibeaux Excel Discussion (Misc queries) 4 June 20th 07 09:05 PM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM
How do I create conditional "List of Values" in Excell? SANCAKLI Excel Discussion (Misc queries) 2 November 9th 05 04:21 PM


All times are GMT +1. The time now is 10:54 PM.

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

About Us

"It's about Microsoft Excel"