Circle chart showing times of the day

Tommyboy30

New Member
Joined
Apr 14, 2021
Messages
1
Office Version
  1. 365
  2. 2007
Platform
  1. 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!
 

Attachments

  • 20210414_103127.jpg
    20210414_103127.jpg
    95.4 KB · Views: 19

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,223,886
Messages
6,175,190
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top