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: 7

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,129,726
Messages
5,638,016
Members
416,999
Latest member
smulttjukken

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
Top