Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Box plots
Can anyone help?
I need to plot my data as a box plot (representing 25th and 75th centile) with error bars representing 10th and 90th centile. Mr Andy Pope gave me a solution but unfortunately it is not working as my 25th centile data is often negative and therefore the stacked column method does not work. Thanks John |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Box plots
Hi
Have a look he http://peltiertech.com/Excel/Charts/ChartIndex.html and scroll down to "Box and whisker plots" -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "JRD" wrote: Can anyone help? I need to plot my data as a box plot (representing 25th and 75th centile) with error bars representing 10th and 90th centile. Mr Andy Pope gave me a solution but unfortunately it is not working as my 25th centile data is often negative and therefore the stacked column method does not work. Thanks John |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Box plots
You have to combine the more complicated data structure of this tutorial:
http://peltiertech.com/Excel/Charts/...eAndBelow.html with the box and whisker example he http://peltiertech.com/Excel/Charts/BoxWhiskerV.html Alternatively the Box and Whisker Utility (http://peltiertech.com/Excel/Charts/BoxWhisker.html) generates a box and whisker chart from any data set, including sets with positive and negative values. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wigi" wrote in message ... Hi Have a look he http://peltiertech.com/Excel/Charts/ChartIndex.html and scroll down to "Box and whisker plots" -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "JRD" wrote: Can anyone help? I need to plot my data as a box plot (representing 25th and 75th centile) with error bars representing 10th and 90th centile. Mr Andy Pope gave me a solution but unfortunately it is not working as my 25th centile data is often negative and therefore the stacked column method does not work. Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you create Box Plots (Box-and-Whisker Plots) in Excel? | Charts and Charting in Excel | |||
Box Plots | Setting up and Configuration of Excel | |||
Excel gives me line plots - I want scatter plots | Charts and Charting in Excel | |||
q-q plots | Charts and Charting in Excel | |||
Box plots | Charts and Charting in Excel |