Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-11-2014, 01:30 AM   #1
hendy13
Newly Registered User
 
Join Date: Mar 2014
Posts: 15
Thanks: 2
Thanked 0 Times in 0 Posts
hendy13 is on a distinguished road
Data label on chart not showing the percentage value

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
Attached Images
File Type: jpg pic001.jpg (67.0 KB, 119 views)
File Type: jpg pic002.jpg (41.3 KB, 77 views)
File Type: jpg pic003.jpg (39.7 KB, 90 views)

hendy13 is offline   Reply With Quote
Old 03-11-2014, 04:04 AM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,702
Thanks: 2
Thanked 2,072 Times in 2,027 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Data label on chart not showing the percentage value

Open the form/chart in design view and change the x-axis to percent.
Attached Images
File Type: jpg Percent.jpg (49.8 KB, 442 views)
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
hendy13 (03-11-2014)
Old 03-11-2014, 04:16 PM   #3
hendy13
Newly Registered User
 
Join Date: Mar 2014
Posts: 15
Thanks: 2
Thanked 0 Times in 0 Posts
hendy13 is on a distinguished road
Re: Data label on chart not showing the percentage value

@JHB, Thanks a lot. it works

hendy13 is offline   Reply With Quote
Reply

Tags
charts

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross-Tab Chart Percentage Jord Crystal Reports 0 06-08-2012 02:58 AM
Showing Percentage of Completion on a graph? AngeloWolfe Reports 2 11-11-2011 12:40 PM
data label on pivot chart hunterfan48 General 0 05-16-2010 03:28 PM
Showing Percentage in a Query aldeb Queries 1 01-29-2007 08:59 AM
[SOLVED] Chart sometimes showing default chart, why? jjones13 Reports 1 08-31-2003 12:49 PM




All times are GMT -8. The time now is 03:26 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World