Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / July 2008



Tip: Looking for answers? Try searching our database.

Decimals do not appear in a graph data table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fceaman@officeformac.com - 09 Jul 2008 13:19 GMT
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 - 09 Jul 2008 15:42 GMT
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

On 7/9/08 8:19 AM, in article 59b53a14.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.4 (Tiger)
[quoted text clipped - 10 lines]
>
> Cheers,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.