D
Duncs
I have a sheet in Excel 2003 with a number of columns, all of which
follow the same, repeated pattern:
Day of week
Date (dd/mm)
Volume
Blank column
This is then repeated over each month. So, I have 4 columns for
July,
August, September etc. Each of the months have their own individual
line chart, showing date / volume. What I want to do is display a
month on month, running total chart, i.e. the one line chart that
shows all volumes to date. However, I can't get this done the way my
data is stored. If I select multiple columns as my source data, the
sheet shows the one line for each month, when I want the one line for
all months.
Anyone help?
TIA
Duncs
follow the same, repeated pattern:
Day of week
Date (dd/mm)
Volume
Blank column
This is then repeated over each month. So, I have 4 columns for
July,
August, September etc. Each of the months have their own individual
line chart, showing date / volume. What I want to do is display a
month on month, running total chart, i.e. the one line chart that
shows all volumes to date. However, I can't get this done the way my
data is stored. If I select multiple columns as my source data, the
sheet shows the one line for each month, when I want the one line for
all months.
Anyone help?
TIA
Duncs