Loss of formatting in chart data tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
Back
Top