Grouping dates on a Chart
in [General]
|
Prev: How do I stop Excel opening up my PDF documents
Next: Copy a cell from a diferent tab when the tab name is in a cell
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 <peter...(a)verizonXSPAM.net> 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 - |