Scatter charts and data table

[Colin Monteith]

Trying to create a one page report with scatter chart and the data in table
form under the chart in portrait mode. Looks like Excel does not accept this
- has anyone found a work around for this?

Thanks in advance

 

[Andy Pope]

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