Pizza pie chart (Beginner question)

Hi guys,

Help please? I have an Excel file just like this:

Sem-t-tulo.png

I wanted to create a Pizza pie chart showing the amout that each categorie is expending in our company.
But eveytime I try to create it doesn't put together categories that are equal by name. It justs creates a messy Pie Chart.

I wanted the graph to show how much each category costs to our organization...
Like DIR costs R$ 19.000,00, CLT R$ 59.460,00, CLT - RJ R$ 1.800,00

Any idea?

Hello,
Add your data as the source of the pivot table and only after creating the corresponding report, make a graph. Next time, add a file with a data file instead of a photo.
It's very difficult to work on the photos - believe me.

stasinek,

Thanks!!! I'm sorry, I'll upload the file next time!