Merge charts?????

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

I have a chart that displays test scores across the
bottom and how many people got that score on the side.
What I would like to do is graph the Mean, median,
standard deviation stuff like that how do i do it?( on
same graph) Can i do it? Kinda of like a grading curve.

Thanks
Dean
 
Dean,

Here is a possible solution:

Let us assume your class intervals are in column A and your frequencie
are in column B (With numeric class intervals - 20, 30, 40 etc till 6
and not "20-30", "30-40" etc.). Data occupies A1:B6, say

Add two more entries after the largest class interval to represent th
median and mean (In cells A7 and A8). You can use appropriate formula
in these cells to get these values.

In cell C7, add a value x, say 50
In cell D8, add a value y, say 50

Create an XY scatter chart with A1:B8

Now copy cells C2:C8 and paste them as new series on to the chart
Repeat with cells D2:D8

Select series 2->Format Data Series ->YError bars->Custom
Click on - and enter the reference to x (c7)

Repeat for series 3

Now you can format the error bars and series2 and series
appropriately.

If this workaround does not help, then you should consider using tw
charts of different types and use Jon Peltier's 'Jon Peltier's Alig
Charts' (http://peltiertech.com/Excel/Charts/AlignCharts.html) .


- Leni

Attachment filename: mergecharts.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46228
 
Back
Top