The simplest way to provide data for a chart is to use the worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"DavidS" wrote in message
...
Hello, I'd like to ask whether I need to create a column of data for every
line on a chart. For example, I have a column (A) of numbers, one number
for each day. I have created another column (B) for the chart where B1=A1,
B2=B1+A2, B3=B2+A3 etc. In column C I have 1,2,3,4,5,6 etc for the day. If
I want another line on the chart do I need to create column D. Is there a
simpler way of doing this eg. the formula is placed in the chart so I
don't need to create a column for each line. Thanks for your help, David