Create a radial bar chart in Excel - Excel Tips and Tricks

Опубликовано: 04 Октябрь 2024
на канале: Rabi Gurung

4,052

308

Learn how to create a radial bar chart in Excel.

Insert Radial Chart
1) Ctrl+A
2) Insert ~ Charts ~ More Pie Charts...
3) Doughnut
4) Radial chart
5) Ok
6) Resize and reposition
7) Remove title and legend

Height: 9.59 cm
Width: 10.4 cm

Formatting Radial Chart
1) Right-Click ~ Format Chart Area
2) Remove border and fill
3) Select outer ring
4) Series options
5) Hole size = 25%
6) Select "Remaining %" and change to "No Fill"
7) Change "Earning %" to shades of green.

Labeling Radial Chart
1) Insert ~ Text Box
2) Right-Click ~ Format Shape
3) Remove fill and lines
4) Copy and paste "Channels" into Text Box
5) Font Size = 9.5
6) Bold

#tips #excel #shorts #fyp