Formatting number in Data Table

[Scott Christopher]

I am using Excel 2007. I have a spreadsheet that the figures can be
negative or positve. I have formatted the cells with this custom
format $#,##0;[Red]$-#,##0. On the spreadsheet the format works fine.

I created a chart from the data. I have a data table at the bottom of
the chart. The problem is that the format from the spreadsheet is not
reflected in the data table. When I click on Format Data Table, there
is no option for number formatting. There is a number formatting
option available when i click Format Axis, but this doesn't change it,
because the actual axis is Text.

Is there any way to use this format?

Thanks for any help you can give me!

Scott

 

[Shane Devenshire]

Hi,

We have almost no control of the format of data tables. I recommend not
using data tables, instead put a copy (linking formulas) of the data directly
below the chart but in the spreadsheet. There you can format any way you
want.

 

[Scott Christopher]

But doesn't that make it more difficult if you are copying the charts
into a PowerPoint Presentation?


I would click the "Yes" button if I knew where it is.

Thanks for your help.

Scott