pie charts

[Gerrard]

Create a well labelled pie chart on a separate worksheet to show the profit made by each of the Liverpool departments to the overall profit for 2006. On the labels show the percentage contributed by each department.

I want to create a pie chart in Excel 2007. The data is not next to each other in the columns. How do I create a chart so that it includes the legends as the various departments and the data shown as the figures given under 2006?

I also need to put this on a separate sheet, aptly labeled pie chart.

Thanks for your time

 

[Gerrard]

solved