Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display sample population size in chart i.e. n=X
Hi,
Does anyone know if Excel can display the sample group population within the chart i.e. N=100, (if 100 people answered the question) obviously this can be done manually but it would be cool if excel could do it itself. The reason I want to do this is so the reader of the graph can gauge the significance of the % figures, my chart is reading of a pivot table wich I plan to update over time with new data so has to be dynamic, maybe there is another solution which could work, Thanks, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display sample population size in chart i.e. n=X
Here is one way.
If you create a formula in a cell with a count of the sample, and maybe some explanatory text as well, you can use that in the chart title. Select the chart title, and then in the formula bar, add a reference to that cell, such as =Sheet1!D1 (include the sheet). -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dulouz" wrote in message ... Hi, Does anyone know if Excel can display the sample group population within the chart i.e. N=100, (if 100 people answered the question) obviously this can be done manually but it would be cool if excel could do it itself. The reason I want to do this is so the reader of the graph can gauge the significance of the % figures, my chart is reading of a pivot table wich I plan to update over time with new data so has to be dynamic, maybe there is another solution which could work, Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sample Size and Confidence Interval | Excel Discussion (Misc queries) | |||
Pull a Sample from a Population | Excel Worksheet Functions | |||
Population Chart with 1 dataset | Excel Discussion (Misc queries) | |||
Population Chart with 1 dataset | Excel Discussion (Misc queries) | |||
In a yes or no situation how do I choose a sample size | Excel Discussion (Misc queries) |