View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default Cumulative data charts

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Susannem" wrote in message
...
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.