Percent of time chart

[wcleve]

Help...I am not sure how to word this, but here goes...well, here's an example of what i'm trying to determine...

At 1pm, 5% of the time the temperature is within this x range, 10% of the time the temp is within x range, 20% and so on as necessary.

Line chart - The series would be the 1pm temps for June, July and August. The x axis should show the percents of time and the y axis show the temp.

With that, I have a pivot table I'm using to help filter the data, but not sure if I need to use it or what to determine "the percentage of time" something occurs and then plot it. I've tried using a histogram but only get cumulative percentages.

Hope this is clear.

Thanks!

 

[GlennUK]

Nope, this is not clear. The explanation of the data is not detailed enough, and I cannot fathom what you'd want in your graph ( but, obviously I'd have more chance if I could envisage the data ). Can you give a portion of the data so as to be able to see what's going on?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.