Decimals do not appear in a graph data table

[fceaman]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

When plotting a data table in a graph, numbers appear with no decimals even if they are written with one decimal in the source. If i want to give format to the data table, the tab "number" does not appear...

Besides, the decimals appear if the Excel file is open in a Windows version office.

Thank you to anyone who could help me!

Cheers,

 

[CyberTaz]

I'm not seeing that here

Formatting of the numbers in the Data Table is dynamically linked to that of
the cells in the sheet. The only time there is any difference is if there
are a large number of values being plotted in a relatively small amount of
space - but that's another [understandable] matter.

The Data Table, however, is an object rather than a grid of cells. If you
select it you can use the regular Font formatting features to make a global
change to its entire content but the Number formatting can't be changed.

Regards |:>)
Bob Jones
[MVP] Office:Mac