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)

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.

Originally Posted by knuuttila

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" <knuuttila@discussions.microsoft.com> wrote in message
news:87079CE1-D737-4687-AA20-9FB093B91540@microsoft.com...
>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)