From: Duncs on 29 Mar 2010 06:38 I have a workbook with 12 sheets in it, one for each month of the year. Each sheet has the day of the week in column B, several other values in columns C -- J and a transaction value in column K. What I want to do is create a chart that groups the dates into days of the week and then displays a bar showing the sum of all transactions on each of those days in the month. So, for example, the sheet for March would show: 1 x x x x x x x x 1250.00 2 x x x x x x x x 80.00 3 x x x x x x x x 3000.00 4 x x x x x x x x 5250.00 .. .. .. 30 x x x x x x x x 150.00 31 x x x x x x x x 100.00 So, based on the values above, the chart should show 7 bars with the values as follows: Monday 1250.00 Tuesday 230.00 Wednesday 3100.00 Thursday 5250.00 Friday 0.00 Saturday 0.00 Sunday 0.00 How do I achieve this? TIA Duncs From: Dave Peterson on 29 Mar 2010 09:28 Check your other post. Duncs wrote:> > I have a workbook with 12 sheets in it, one for each month of the > year. Each sheet has the day of the week in column B, several other > values in columns C -- J and a transaction value in column K. What I > want to do is create a chart that groups the dates into days of the > week and then displays a bar showing the sum of all transactions on > each of those days in the month. So, for example, the sheet for > March > would show: > > 1 x x x x x x x x 1250.00 > 2 x x x x x x x x 80.00 > 3 x x x x x x x x 3000.00 > 4 x x x x x x x x 5250.00 > . > . > . > 30 x x x x x x x x 150.00 > 31 x x x x x x x x 100.00 > > So, based on the values above, the chart should show 7 bars with the > values as follows: > > Monday 1250.00 > Tuesday 230.00 > Wednesday 3100.00 > Thursday 5250.00 > Friday 0.00 > Saturday 0.00 > Sunday 0.00 > > How do I achieve this? > > TIA > > Duncs -- Dave Peterson From: Duncs on 30 Mar 2010 04:15 Dave, I thought I'd try and cover all bases! Duncs On 29 Mar, 14:28, Dave Peterson wrote:> Check your other post. > > > > > > Duncs wrote: > > > I have a workbook with 12 sheets in it, one for each month of the > > year.  Each sheet has the day of the week in column B, several other > > values in columns C -- J and a transaction value in column K.  What I > > want to do is create a chart that groups the dates into days of the > > week and then displays a bar showing the sum of all transactions on > > each of those days in the month.  So, for example, the sheet for > > March > > would show: > > > 1   x   x   x   x   x   x   x   x   1250.00 > > 2   x   x   x   x   x   x   x   x       80.00 > > 3   x   x   x   x   x   x   x   x   3000.00 > > 4   x   x   x   x   x   x   x   x   5250.00 > > . > > . > > . > > 30   x   x   x   x   x   x   x   x     150.00 > > 31   x   x   x   x   x   x   x   x     100.00 > > > So, based on the values above, the chart should show 7 bars with the > > values as follows: > > > Monday         1250.00 > > Tuesday          230.00 > > Wednesday   3100.00 > > Thursday       5250.00 > > Friday                 0.00 > > Saturday             0.00 > > Sunday               0.00 > > > How do I achieve this? > > > TIA > > > Duncs > > -- > > Dave Peterson- Hide quoted text - > > - Show quoted text -