S
Swansea Jack
Hi All
I know this is simple, but cannot see wood for trees at present !
I have a big spreadsheet that has weekly values of hours worked by activity
for staff members [staff names running down the page, weekly values running
across]. I can produce a simple bar chart with a 'time-scale' x-axis using
total hours booked per week, but I want to summate the weekly values into a
monthly total and plot that. I can change the timescale to months rather than
weeks OK, but the bars are 'stacked' behind each other, rather than a single
overall total per month.
What am I missing here ?? - As it's a big spreadsheet [contains more info
than just this], I'm reluctant to have to manipulate the source data too much
- I hoped I could do it within the charting functions. Any ideas ???
I know this is simple, but cannot see wood for trees at present !
I have a big spreadsheet that has weekly values of hours worked by activity
for staff members [staff names running down the page, weekly values running
across]. I can produce a simple bar chart with a 'time-scale' x-axis using
total hours booked per week, but I want to summate the weekly values into a
monthly total and plot that. I can change the timescale to months rather than
weeks OK, but the bars are 'stacked' behind each other, rather than a single
overall total per month.
What am I missing here ?? - As it's a big spreadsheet [contains more info
than just this], I'm reluctant to have to manipulate the source data too much
- I hoped I could do it within the charting functions. Any ideas ???