Tommyboy30
New Member
- Joined
- Apr 14, 2021
- Messages
- 1
- Office Version
- 365
- 2007
- Platform
- Windows
Hi all, so my problem is this. I want to basically make the attached picture in excel.
What this shows is a 24 hour day, divided into various chunks of X hours. This I can kind of do with a multiple-series donut chart (I need multiple concentric wedges), however the bands are WAY too thin and I can’t seem to get them to increase in thickness (grabbing and dragging only separates the outer ring).
The other thing I want to do is have specific times coming off and being labelled up (so my data in excel would be something like “0700” in one cell, then in the adjacent one would be “Get Up”).
I also have no idea what something like this is called, and various google and forum searches of “radial, time, 24hr, chart” etc. produced fruitless results. So my question is, has anyone seen/done similar to what I want and know how to replicate it? I'm not averse to using macros however I'd prefer a solution that doesn't require them if that's possible.
Many thanks in advance!
What this shows is a 24 hour day, divided into various chunks of X hours. This I can kind of do with a multiple-series donut chart (I need multiple concentric wedges), however the bands are WAY too thin and I can’t seem to get them to increase in thickness (grabbing and dragging only separates the outer ring).
The other thing I want to do is have specific times coming off and being labelled up (so my data in excel would be something like “0700” in one cell, then in the adjacent one would be “Get Up”).
I also have no idea what something like this is called, and various google and forum searches of “radial, time, 24hr, chart” etc. produced fruitless results. So my question is, has anyone seen/done similar to what I want and know how to replicate it? I'm not averse to using macros however I'd prefer a solution that doesn't require them if that's possible.
Many thanks in advance!