Hi

I have created a chart from a pivot table on my laptop (Excel 2003). The data table displays the data as a %, which is what I want.

However, I can't print from my laptop at home so have emailed the Excel file to my home computer, which is a Mac (Excel 2004). I've opened up the file and, although the pivot table looks correct, the data in the chart data table is not displaying as a %. So, on my laptop the data table shows 4.3%, on the Mac it shows 0.0436654545

I can't for the life of me work out how to change the number display in the data table. The option isn't possible in Format Data Table, and the source data is displaying correctly, just not the data table.

Help!