Hello
this is what I want to do
Excel.PNG
I want to make a Pie chart that will list like this
chart.PNG
I'm wanting to know how i can have it combine cells B1 and E1 , B2 and E2, etc
so that the total will show up in the pie chart
so as the data say i want the pie chart to show
Pennies 24
Nickels 0
Dimes 6
Quarters 3
I know that I could cheat and just make a area in my sheet with the grand totals but was wanting to know if there is a different way
Bookmarks