Column chart question

  • Thread starter Thread starter rajgopal
  • Start date Start date
R

rajgopal

How can I group data in column chart?

_Week_ _Day_ _Qty_
1- Fri - 200
2- Fri- 350
3- Fri- 150
1- Sat- 225
2 - Sat -200
3- Sat -100

How do I make column chart with all Fri together and all Sat togethe
and label the weeks
 
You could create a pivot table with Weeks & Days as your axis.

So you will get a table like:
... 1 2 ....
Mon
Tue
...

You can create a stacked bar chart from this table to group your dat
by days and label the weeks.

Hope this helps.

Regards,
Leni
 
Back
Top