Data Tables on Charts

  • Thread starter Thread starter gene
  • Start date Start date
G

gene

I have 2 files. The first has the source data while the
second has the graph that's linked to the data that is in
the first. The chart has the option "Show data table" on.
When both files are open, the data in the data table is
formatted correctly with commas and the correct number of
decimal places (ie 1,250.2). However, when I close the
source data (or just open the chart file alone) the data
table has the values without commas or decimals (ie
1250.222222)

How do I get the data table of the chart file to retain
the formatting without having to open the source??

I am using Excel 2002 with SP1

ANY help would be greatly appreciated!!

Thanks in advance
 
Back
Top