excel scatter graph ... how get a data table

[Jim Nagler]

Noticed that on a scatter type graph, an option is not
presented to display a data table with the graph.

Has anyone found a way to do this?

Thanks

...Jim

[Andy Pope]

Hi Jim,

What exactly would you want displayed in the Data table if it were possible?

When a normal datatable is a matrix of rows(series) by
columns(categorys) displaying values.

--

Cheers
Andy

http://www.andypope.info

[Jon Peltier]

Jim -

Why not create a table of data in the rows below the chart? This way,
you can control what goes into the table, and how everything is
formatted. I prefer this to data tables in any case.

I think the philosophy of data tables is that for Line or Column charts,
you have evenly spaced data across the X axis, so you can construct an
evenly spaced table, with relevant numbers underneath the category
labels. By definition, data in a Scatter chart can lie anywhere, so a
data table would not be as descriptive.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> ....Jim

[Jim Nagler]

A table of data is what I wanted, only as a part of the
chart
(in this way, it would be easier to move around in word
documents).
The data would be movable in the chart, something like a
ledgend
and look something like:

Series1ident Series2ident
Y-values X-values Y-values X-values
1487 1.2 2974 1.3
3024 1.3 6049 1.4
4554 1.4 9110 1.8
6014 1.6 12029 2.2
7544 2.3 15077 2.6
9099 2.2 18202 3.1
10632 2.5 21227 3.5
12124 3.3 24288 4.3
13637 4.1 27364 5.6
15246 5.2 30549 10.4
16014 11.1

???

...Jim
not sure how to attach here, so will send
a sample by email

>.
>