A chart's data table won't inherit theformat of field from query-n

[Nicholajlg]

I created a chart within a report,both report & chart are based on the same
query. The field in the query is a percent, the field in the chart's data
table is just the number with 10 decimal places. How do I make the data
table keep the queries format?

 

[SA]

Nich:

Open the chart in design mode and in the data sheet where sample (or your
real) data is shown, right click on the column header and select format
(like in XL) and set your number format there.