how to select specific cells to product a chart
 

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)

Hi knuuttila,

This should get you started: http://peltiertech.com/Excel/Charts/index.html
And more specifically this:
http://peltiertech.com/Excel/Charts/Dynamics.html

Regards,
KL


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

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