Best way to visualize histogram over time?

Status
Not open for further replies.

KingGheedora

Diamond Member
Jun 24, 2006
3,248
1
81
I have a data set where I have a histogram for each year over a sequence of years. Is there a best way to visually represent this data so one can best compare how the histograms changed over time?
 

Mo0o

Lifer
Jul 31, 2001
24,227
3
76
how about a 3D histogram? I'm pretty sure excel has a way to do it
 

dullard

Elite Member
May 21, 2001
25,820
4,378
126
I like two methods, depending on how complex it is.
1) It it is a smooth, not too complex histogram, then draw an x-y line graph through the top of all points. Then overlay one x-y line graph over the others. After about a half dozen, it'll get too busy.

2) If it is a bumpy, complex histogram, then do the same x-y line graph but this time put many small graphs next to each other. Think of a 2x2 grid or a 3x3 grid of x-y line graphs.

Anything else probably is too messy and you should think about what data to exclude.
 
Status
Not open for further replies.