Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
Excel adds a "1" to filenames opened from desktop shortcut | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
How do I create conditional "List of Values" in Excell? | Excel Discussion (Misc queries) |