Need to make a bar chart from subtotals

P

pattytydings

I have a table with the headings Type, Date, Number of Items, and it is
sorted by Type and then by Date. I have made subtotals of the Number of Items
for each Type on each Date. Now, I want to make a stacked-column bar chart
where there is a bar for each date and the colors in the stacked bars are
broken down by Type. I cannot for the life of me figure out how to get Excel
to generate this bar chart just from my subtotals. I actually have MANY of
these to make and thousands of items in each table. Please help me!
 
S

smartin

pattytydings said:
I have a table with the headings Type, Date, Number of Items, and it is
sorted by Type and then by Date. I have made subtotals of the Number of Items
for each Type on each Date. Now, I want to make a stacked-column bar chart
where there is a bar for each date and the colors in the stacked bars are
broken down by Type. I cannot for the life of me figure out how to get Excel
to generate this bar chart just from my subtotals. I actually have MANY of
these to make and thousands of items in each table. Please help me!

Subtotals are an unwieldy way to do this. Have a look at

http://vfdrake.home.comcast.net/files/excel/stacked_bar_chart.xls
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top