Link to home
Create AccountLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Pie chart formatting

Hi,

Ive made a few pies on the same spreadsheet.

I need the formatting to be consistent. E.G the largest slice should be purple, the next slice should be green, the next orange and the lowest slcie black.

Can anyone tell how to do this?

Thanks
Avatar of chrismanncalgavin
chrismanncalgavin

Have you tried copying and pasting to duplicate the pie chart a few times, and then right click each one, then choose "Select Data".
That way you are using the same chart as a template, but pointing it to different sets of data.

If you are using Excel 2010 also, there is a "Design" ribbon option with chart styles. This is a feature that lets you style charts a bit quicker / easier than earlier versions.
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Seamus2626

ASKER

Thanks Chris, but Teylans answer was the one i needed

Cheers

Seamus