HMRC Tax Chart - How to create

[PeterA]

Hi

Has anyonse seent the new HMRC letter that is sent out

The chart looks like this

HMRC Chart.JPG

But we do not know how to create it, but would like to .

Kind regards

Peter

[Olly]

	A	B
1	Welfare	1266
2	Health	974
3	Education	679
4	State Pensions	626
5	National debt interest	361
6	etc…

Select the range, then Insert > Charts> Other Charts > Doughnut Chart.

[PeterA]

Hi Olly,

Nice to see a reply from Darlo,

Thanks for the quick reply.

However do you know how to make it exactly like the one in the picture, with the different areas around the chart with the little lines showing you where everything was and the title and total in the middle.

I have tried formatting it but it does not seem to help much.

Kind regards

Peter

[Olly]

Excel doesn't offer the option of leader lines on a doughnut chart, but does on a pie chart - so you could duplicate your data, plot the second series as a pie chart with no fill or border, and format data labels with leader lines. You'll probably still have to do some manual formatting and positioning of the labels if you want to precisely replicate your example chart, though.

For the label in the centre, you can simply add a shape with a caption linked to a cell containing your caption text.

See attachment for an example of how all this can work. Note the chart source data is in range D2:F16, behind the chart.

[PeterA]

Absolutely Incredible, I don't know how you did it, I will go and have a play.
Kind regards
Peter