Need advice on graph?

[Joeseph Dafow]

I have to make a graph which shows the temprature changes in a series of
containers. I have 52 containers and I plot a graph using levels
measured each month. The graph is to be displayed as a 4 Blocker to
management but with 52 different lines going up and down and all over
it is very hard to see any real trends in the graph. What I would like
to know is if there is any better ways such as 3d graphs etc to
represent this info and how I might go about doing this as I have
limited excel knowledge.
Thanks in advance,
Joe

 

[mrice]

I've had similar problems. Something that has worked for me is to sort
the data such that at least one of the time points the individual
lines, the values increase or decrease monotonically.

Alternatively, you might like to abstract the data into a simpler form
showing a single value for the average and the standard deviation or
hi-lo points. It depends upon the message that you are trying to get
across.

Hope this helps.

Martin