Graph with median and individual points

**deraj727** · 08-14-2016, 10:31 PM

I am wanting help to make a graph that shows the median but in addition also shows the individual points.

Thanks!

**MrShorty** · 08-14-2016, 11:22 PM

We will almost certainly need more details about the kind of graph you want, the data that you have, and how you have arranged the data in the spreadsheet.

1st question I will ask back -- in order to chart the median, you will need to calculate the median in the spreadsheet. Are you able to compute the median (using the MEDIAN() or other suitable function)?

**deraj727** · 08-15-2016, 01:38 AM

Yup, I can calculate the median. Im just not sure how to show both the median as well as the individual data.

For example I have theses data points

0.666666667
0.764705882
1.282051282

0.377777778
0.475
0.593220339
0.935483871

Thanks!

**MrShorty** · 08-15-2016, 10:28 AM

I still think we need more information. What chart type do you want to use? What is the chart supposed to communicate?

In the attached file, I simply added the median formula and inserted a column chart. All seven data points are displayed and the median, so this technically does what you asked for, but it probably is not what you have in mind.