| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How may I macro update a normal distribution chart from new data?
In Excel 2003 SP2. I have created a form for reporting Statistical
values.This includes a normal distribution chart. I want to update this chart when new sample data is entered into the form, without having to go through "Tools, Data Analysis, Histogram" each time. I have already tried recording my steps, with "Record New Macro" in the tools menu, but this does not work. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How may I macro update a normal distribution chart from new data?
The histogram is plotted from a table of bin ranges and counts. If you
change those table values into formulas, then the histogram will update with those formulas. Jerry "Mike Williams" wrote: In Excel 2003 SP2. I have created a form for reporting Statistical values.This includes a normal distribution chart. I want to update this chart when new sample data is entered into the form, without having to go through "Tools, Data Analysis, Histogram" each time. I have already tried recording my steps, with "Record New Macro" in the tools menu, but this does not work. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How may I macro update a normal distribution chart from new da
Thanks for the reply Jerry,
How do I change the table values into formulae? Will this cause the chart to update when a new set of sample data is entered? Mike "Jerry W. Lewis" wrote: The histogram is plotted from a table of bin ranges and counts. If you change those table values into formulas, then the histogram will update with those formulas. Jerry "Mike Williams" wrote: In Excel 2003 SP2. I have created a form for reporting Statistical values.This includes a normal distribution chart. I want to update this chart when new sample data is entered into the form, without having to go through "Tools, Data Analysis, Histogram" each time. I have already tried recording my steps, with "Record New Macro" in the tools menu, but this does not work. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How may I macro update a normal distribution chart from new da
See Help for the COUNTIF worksheet function.
Excel's bin labels give the upper limit of the bin. If the bin labels start in A2, then a formula like =IF(A2="More",COUNT(dataRange)-COUNTIF(dataRange,"<="&A1),COUNTIF(dataRange,"<="& A2)-COUNTIF(dataRange,"<="&A1)) in B2 and copied down over the following bin count cells would give histogram bins tat would update as the data changes. Jerry "Mike Williams" wrote: Thanks for the reply Jerry, How do I change the table values into formulae? Will this cause the chart to update when a new set of sample data is entered? Mike "Jerry W. Lewis" wrote: The histogram is plotted from a table of bin ranges and counts. If you change those table values into formulas, then the histogram will update with those formulas. Jerry "Mike Williams" wrote: In Excel 2003 SP2. I have created a form for reporting Statistical values.This includes a normal distribution chart. I want to update this chart when new sample data is entered into the form, without having to go through "Tools, Data Analysis, Histogram" each time. I have already tried recording my steps, with "Record New Macro" in the tools menu, but this does not work. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How may I macro update a normal distribution chart from new da
Thanks again Jerry.
Best regards, Mike "Jerry W. Lewis" wrote: See Help for the COUNTIF worksheet function. Excel's bin labels give the upper limit of the bin. If the bin labels start in A2, then a formula like =IF(A2="More",COUNT(dataRange)-COUNTIF(dataRange,"<="&A1),COUNTIF(dataRange,"<="& A2)-COUNTIF(dataRange,"<="&A1)) in B2 and copied down over the following bin count cells would give histogram bins tat would update as the data changes. Jerry "Mike Williams" wrote: Thanks for the reply Jerry, How do I change the table values into formulae? Will this cause the chart to update when a new set of sample data is entered? Mike "Jerry W. Lewis" wrote: The histogram is plotted from a table of bin ranges and counts. If you change those table values into formulas, then the histogram will update with those formulas. Jerry "Mike Williams" wrote: In Excel 2003 SP2. I have created a form for reporting Statistical values.This includes a normal distribution chart. I want to update this chart when new sample data is entered into the form, without having to go through "Tools, Data Analysis, Histogram" each time. I have already tried recording my steps, with "Record New Macro" in the tools menu, but this does not work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Use a macro to expand data series for chart? | Charts and Charting in Excel | |||
| Excel 2007 - How do I quickly update a chart using Source data? | Charts and Charting in Excel | |||
| Format a chart to automatically update with last 26 data points? | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
Linear Mode
