| View previous topic :: View next topic |
| Author |
Message |
essenceofinsanity
Newbie
Joined: 22 Apr 2012
Posts: 1
|
 Posted: Sun Apr 22, 2012 8:42 pm Post subject: Graph of mean values with range bars |
 |
|
| I have to create a column graph of the mean number of push ups done by males vs females, with a range bar of the highest and lowest number for each column, but I have no idea how to do it! I was given all the sets of data in a spreadsheet, without the mean. The question is, can I create a column graph of the data, and then put range bars in? Do I have to find the mean and graph that? HELP!!! |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
| Posted: Sun Apr 22, 2012 10:26 pm Post subject: |
|
|
Do you mean like in attached doc (Error Bars to show range.ods)?...
http://www.mediafire.com/view/?btuyo6u4p6wxbbq
Error bars show range when calculated using AVERAGE, MIN and MAX functions.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Last edited by ken johnson on Sun Sep 23, 2012 9:53 pm; edited 1 time in total |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Apr 26, 2012 4:38 am Post subject: |
|
|
Nice work but a really ugly dynamite chart. 
@essenceofinsanity
A column (bar) chart with ranges is a really bad way to display the data that you have. You can use Ken's approach but change the chart type to xy-graph to get a much better graphic
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
