Charting multiple column data

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top