how to select specific cells to product a chart

K

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)
 
B

Bryan Hessey

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.
 
Top