Thanks. It sounds as if the writer of that article has been down the path to
no solution within the chart process. I'm going to give the separate table
approach a try. It sounds good. Thanks, again for the tip.

"owl37" wrote:

> Hi,
> THanks for your reply to my questions.
> Have a look at this website
> http://pubs.logicalexpressions.com/P...?ID=209#jon021
> About data tables.
> Basically saying they are limited in what they can do and it is better to
> embed a chart and add in a data table manually.
> Hope this helps.
> Thanks.
>
> "Chartsmalm" wrote:
>
> > 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!!