Column chart question

[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

 

[LeninVMS]

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