Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Let's say you have, starting in A1:
quantity.......count......cumulative 1.................3 2.................5 4..................9 5..................11 etc So for the thing being measured (X), when x=1 you have a frequency of 3; when x=2 frequency = 5, etc In A2 enter =SUM($A$2:A2) and copy down the column Now select A1:A(whatever); hold CTRL and highlight C1:C(whatever) - that's how to select non-adjacent ranges The hit the Chart Wizard tool and you are away. Need more? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Student in need of help!!" <Student in need of wrote in message ... |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I show how to make a cumulative probability chart using a similar approach
to Bernard's on this web page: http://peltiertech.com/Excel/Charts/...lityChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Bernard Liengme" wrote in message ... Let's say you have, starting in A1: quantity.......count......cumulative 1.................3 2.................5 4..................9 5..................11 etc So for the thing being measured (X), when x=1 you have a frequency of 3; when x=2 frequency = 5, etc In A2 enter =SUM($A$2:A2) and copy down the column Now select A1:A(whatever); hold CTRL and highlight C1:C(whatever) - that's how to select non-adjacent ranges The hit the Chart Wizard tool and you are away. Need more? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Student in need of help!!" <Student in need of wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i create a bridge graph in excel? | Charts and Charting in Excel | |||
Help an Excel novice with a graph formula? | Excel Discussion (Misc queries) | |||
How can I create a graph or something like a receipt on Excel? | Excel Discussion (Misc queries) | |||
create menus in excel worksheet | Excel Worksheet Functions | |||
Copying an Excel Graph to PowerPoint | Charts and Charting in Excel |