knuuttila,

There may be easier ways, but I would select a range of cells to act
for the chart, and in those cells put =A1 =B3 =D7 to collect the
data required from a1, b3 and d7 to display in the chart.




knuuttila Wrote:
I have a large spreadsheet which contains lots of different data,but I
want
to create a chart using only selected data from differt parts of the
spreadsheet.


How do I do this?

I,m sure this is simple, but I can,t work it out.

Thanks(very new to charting)


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395639