Fancy Graph

[DEllis]

I have a spread sheet and in Column A there are a list of areas Column B there are 2 types of data (Direct and Indirect) and column C has the sums for direct and Indirect.

So the spread sheet would look like

Group A Direct $4
Group A Indirect $3
Group B Direct $6
Group B Indirect $8

Is there a way to make a chart that shows the sums for each Group?

Thanks.

 

[Steve=True]

If I understand correctly, the easiest way would be to flip your data as such:

................Direct............Indirect
Group A........4....................6
Group B........3....................8

Then highlight the range and insert a Stacked Column Chart (not 100% stacked)

Direct will appear on bottom with indirect on top combined by Group on the x axis.

Steve=True
www.exceldashboardtemplates.com

 

[Swagg]

You could also use a pivotable and then create a chart of your pivot table.


Sum of Amount D/I
Group Direct Indirect Grand Total
Group A $4.00 $3.00 $7.00
Group B $6.00 $8.00 $14.00
Grand Total $10.00 $11.00 $21.00

 

[DEllis]

Thank you both! I tried both and both methods worked beautifully. I appreciate the quick response.

Have a great week.