Data label on chart not showing the percentage value (1 Viewer)

hendy13

Registered User.
Local time
Today, 21:04
Joined
Mar 5, 2014
Messages
15
Good Day Developers, so i already searching for many hours but can not find any answer for my problem. so i create a table called weld_performance. it consist weld_id, weld_prod, total_rt, accepted, rejected, and rejection rate. from weld_prod until rejection rate, the type data is number. the rejection rate field size is Single, and Format is Percent.

Based on this table, i create a query called query1. and based on this query1, i create a chart. please see attachment pic001. as you can see the data label on the chart is showing 0.66667. but in my query1, the value is 67%. if i click the value (67%) it's change to 0.66667.

so i guess, the chart is read the 0.66667 value from the query. now what i want to ask is, how can my chart data label is shown 67% instead of 0.66667 ??

any help would be very appreciated. Environment: Windows 7, Ms. Access 2010
 

Attachments

  • pic001.jpg
    pic001.jpg
    67 KB · Views: 163
  • pic002.jpg
    pic002.jpg
    41.3 KB · Views: 122
  • pic003.jpg
    pic003.jpg
    39.7 KB · Views: 152

JHB

Have been here a while
Local time
Today, 15:04
Joined
Jun 17, 2012
Messages
7,732
Open the form/chart in design view and change the x-axis to percent.
 

Attachments

  • Percent.jpg
    Percent.jpg
    49.8 KB · Views: 855

hendy13

Registered User.
Local time
Today, 21:04
Joined
Mar 5, 2014
Messages
15
@JHB, Thanks a lot. it works :D
 

Users who are viewing this thread

Top Bottom