When an Excel sheet containing a chart is copied to a new book, leaving it's
data behind, the chart retains the data values and data point values continue
to be displayed with the original formatting.

Unfortunately values in a data table loose their formatting, so what
appeared as 78% in the original data t able, now appears as 0.78956302

Is there a method of formatiing a data table without having to have the
original source data in the same workbook?

Excel 2003

Data tables are really limited, and this is only a small part of their
limitation. If you use an embedded chart, the best alternative is to build a
table in a range of cells adjacent to the chart, which allows full
formatting as well as the ability to include and exclude data from the table
at will. If you use a chart sheet, the best alternative is to use the camera
tool to take a dynamic picture of a specially designed table, and place it
on the chart sheet. The camera tool can be added to any convenient toolbar
as follows: Go to View menu Toolbars Customize, click on the Commands
tab, select Tools from the Categories list on the left, and scroll down in
the right list until you see the Camera tool; drag this icon to the toolbar.

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

"John Richmond, Watford UK"
wrote in message
...
When an Excel sheet containing a chart is copied to a new book, leaving
it's
data behind, the chart retains the data values and data point values
continue
to be displayed with the original formatting.

Unfortunately values in a data table loose their formatting, so what
appeared as 78% in the original data t able, now appears as 0.78956302

Is there a method of formatiing a data table without having to have the
original source data in the same workbook?

Excel 2003

For an alternative to Data Tables, see
Custom Chart Table
http://www.tushar-mehta.com/excel/ne...able/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
When an Excel sheet containing a chart is copied to a new book, leaving it's
data behind, the chart retains the data values and data point values continue
to be displayed with the original formatting.

Unfortunately values in a data table loose their formatting, so what
appeared as 78% in the original data t able, now appears as 0.78956302

Is there a method of formatiing a data table without having to have the
original source data in the same workbook?

Excel 2003