You may also want to look at
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...
I prefer that the Data Table on a specific chart be formatted n,nnn,nnn as
all raw data is without cents. The cells used as reference for the chart are
formatted in the above manner.

On the worksheet where the chart is built the formnatting is n,nnn,nnn.00.
The 00 is consistent because the data has no cents.

The chart building workbook is a master that is used over and over for
changing situations. So, the chart is copied to its own single sheet
workbook for distribution and posterity. At this point the formatting
problem gets worse. The commas disappear and now I have nnnnnnn - with no
cents. Thank heaven that the 00 cents didn't come thru. The chart would
have been absolutely unusable in that state.

As it is we can use it as it is, with the explanation to the viewer: "Excel
drops the commas. We're exploring the problem. You'll have to pen them in for
now!"

I can't believe that there is no way to control the fomat of this region
when there is so much control over all other aspects of the chart building
process. I simply cannot find it!!! Help!!