XY Scatter Chart

[fwshaw]

I need some help with an XY Scatter chart. I need to add a data table
to the chart. Is there a way to do this? I routinely add the data
table to line and bar charts. In this case the data needs to be in the
xy scatter format.

Thanks

 

[Bernard Liengme]

Here is a works around, I will assume the data is in columns
Select the data and copy
Move to an unused part of the worksheet; used Edit | Paste Special, specify
Transpose
Put borders on the new 'table' and adjust the column width
Select the new table; with SHIFT help down use Edit; use the Copy as Picture
item
Move to your chart and copy the picture on the bottom of the chart.
Not great but all I can suggest!
best wishes