Cumulative data charts

G

Guest

Hi,
Is it possible to create a chart which is linked to a table of individual
months' figures but charts the CUMULATIVE year to date figures? I know I can
create a table with the cumulative data to link it to but what I would like
to have is the individual monthly figures showing in the data table but the
year to date figures plotted.

Any help would be much appreciated.
 
B

Bernard Liengme

How about:
column A - months
column B - data
column C - cumulative
Make chart from A,B and C
Format B data with no markers & no lines (i.e. invisible)
Both sets of data show on table
Any help?
 

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

Similar Threads

Line Charts - Is this possible? 3
Line and Bar on same chart 2
cumulative 1
trying to swap axes on chart 4
Copying embedded charts 1
Chart showing different data than listed 3
Charting only partial data from a large dataset 2
How to show a cumulative value over time in a pivot chart. 1

Top