You are Here: Home >< Maths

# Which graph? watch

1. What kind of graph should i use to show the distribution of continuous data, that i can draw using excel07.

I wanted to do a boxplot but excel doesnt draw boxplots *easily* (please noone link me to that horible tutorial of how to do a sideaway bar chart and make bits invisible to make it look like a crappy boxplot)

edit: btw there are like 400 bits of data so a scatter graph isnt really ideal
2. Scatter graph is best, with a line of best fit if appropriate. Or a bar chart.
3. (Original post by Callipygian)
What kind of graph should i use to show the distribution of continuous data, that i can draw using excel07.

I wanted to do a boxplot but excel doesnt draw boxplots *easily* (please noone link me to that horible tutorial of how to do a sideaway bar chart and make bits invisible to make it look like a crappy boxplot)

edit: btw there are like 400 bits of data so a scatter graph isnt really ideal
Excel does histograms - look in the help section to get started.
4. (Original post by James)
Scatter graph is best, with a line of best fit if appropriate. Or a bar chart.
Sorry i didnt make it very clear, the data is life expectancy, so i just have 400 bit of data that at like 70.4, 69.3 etc. a bar chart wouldnt work at all, and a scatter graph is impossible since what do i plot life expectancy against.....

I wanted to avoid grouping the data but i guess a histrogram is probably my best option, its so stupid excel doesn't do box plots theyre way more commonly used than some of the random charts they have got

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: November 16, 2008
Today on TSR

Will it ever be possible?

### University open days

1. University of Cambridge
Wed, 26 Sep '18
2. Norwich University of the Arts
Fri, 28 Sep '18
3. Edge Hill University
Faculty of Health and Social Care Undergraduate
Sat, 29 Sep '18
Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams