Are you referring to "Paste Special - Transpose"? If so, yes I have. However,
it transposes data. It will not transpose the cell references. If it doesn't
transpose the cell references then someone will have to copy the data and
Paste Special - transpose monthly. This isn't acceptable.

"David Biddulph" wrote:

Have you tried using the TRANSPOSE function?
--
David Biddulph

"RW" wrote in message
...
Yes, you are correct. Except that the data in the data table is transposed
from the data on the worksheet. I have about 50 charts in a workbook that
are
linked to powerpoint. The boss now wants to do away with the charts and
only
present the data as formatted in the data table.

I tried to copy the data and transpose paste in another area of the
worksheet but that would have to manually be done every month. I was
hoping
that the paste special had a setting to paste cell references but I
couldn't
find it. After that I thought about somehow just using the data table on
the
chart.

Of course, I could set up the transpose cell references manually but that
will take a long time since one can not enter a cell reference and use
fill
to fill the rest (due to the transposition) unless I just don't know how
to
do it.

BTW, the data in the database is in a format that one can not use a query
to
get the layout needed. thanks for any additional help you can provide.

"Jon Peltier" wrote:

Gee, I thought that's what the worksheet was for. I make my own data
tables
in the worksheet, so I can select what data to include and how to format
it.
The data tables built into charts are notoriously inflexible.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RW" wrote in message
...
Is there a way to display the data table only and have the size of the
data
table be very close to the size of the chart area?

I've succeeded in removing the graph but when I shrink the chart, the
data
table gets smaller also. Any help is appreciated.