Time Wheel Chart

[geospatial]

Trying to find the best way to create a time wheel chart where data is plotted as points by day of the month and hour of the day. The circular area would be a 24 hour period so each pie would be one hour. The divisions going from center of circle out to the outer edge would be 31 days. I have not found a good way to do this yet.

Would appreciate any help.

 

[pgc01]

Hi

Did you try a doughnut chart?

 

[geospatial]

I have, but it did not give me the results I was looking for.

I have an example image on my computer, but I cannot attach it here.

 

[pgc01]

I was thinking of something like the Filled Doughnut from Andy Pope, but with all 24 slices with the same value across all 31 series.

Pie charts

 

[geospatial]

Thanks.

I will have to look later. That site is blocked from government computers. Ill respond tonight. From doing research the closest I found from things I can get to at work is a W.D. Gann wheel chart or "wheel in a wheel".

 

[pgc01]

Ok.

I must say it's a curious layout for the data.

I'd say that it seems much simpler a rectangular grid 24x31 (doesn't even need to be a chart), but you must have your reasons.

 

[geospatial]

Its a major part of pattern analysis which helps to identify groups of patterns. Its the one chart that is briefed for use in all government intelligence schools, but without all the specialized software that builds it for you, its almost impossible to build out. The one way I have found is to make a column that breaks down 31 days by minutes and then in another column putting a 1 there to get it to display.