Hi,
Use the cells of a normal worksheet to hold the data you want displayed.
This may mean moving the chart sheet to an embedded chart object.
For more info,
http://tushar-mehta.com/excel/newsgroups/data_table/index.htm
Cheers
Andy

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
> Trying to create a one page report with scatter chart and the data in
> table
[quoted text clipped - 3 lines]
>
> Thanks in advance