Solved

Making Charts

Posted on 2012-03-16
17
211 Views
Last Modified: 2012-03-16
I have a report that I need to add a chart. However when I make the chart the data in the fields do not match the reports data. I know I can input the correct data, but that will take forever. How do I make the data from the report match the data from the chart? I need the chart to show the locations as the headers and the data would be the precentage of "Defective Items" for each location.  Below is my database. It includes the report that I am working on.
Inventory3-db.accdb
0
Comment
Question by:gigifarrow
  • 11
  • 6
17 Comments
 

Author Comment

by:gigifarrow
ID: 37729501
is there anybody out there that can help me it has been over 2 hrs.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37729521
Two hours is not that long to wait....

Remember, we are all volunteers here...
;-)
0
 

Author Comment

by:gigifarrow
ID: 37729548
I understand what you are saying. However, I am paying for this every month.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37729577
Again, a lot of detail is missing here...

In order to get a "Perentage" you need two things
1. The Total Items
2. ...and the Total Defective Items

So if you had 123 items and 51 were defective, the formula for the percent would be:
51/123=.415
...or 41.5%.

In your report you only the defective Items (by Location) are listed.
Where can I find the "Total" items by location

JeffCoachman
0
 

Author Comment

by:gigifarrow
ID: 37729685
I hope this is what you are asking. If you look at the report after it names each defect there is a total.  Then there is a grand total of all the defective Items. I hope those are the totals you are asking about.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37729760
This is why I always as for:
A Clear, Graphical example of the exact output you are requesting...

In other words what *exactly* do you want displayed"
(The actual Values)

Put another way, show me the *exact* percent values you want for each record/group.

In other words, do you want the Korea percents to be the percentage of the Korea Total , or the grand Total...?


Put another way, this is all I need:
Show me what you have (you have done this)
Show me what you want (don't describe what you want, *Show* me *exactly and graphically* what you want.)


JeffCoachman
0
 

Author Comment

by:gigifarrow
ID: 37729866
This is an example the precentage is not right  so i need the precentage of each by location.  These equation needs to be in a chart. I can make a chart but it just gives me a generic chart.



Location           defect           total

Korea               Leakage          5
                         Loss                2

grand total                              7  = 20%



Colorado         Leakage          3
                       Loss                1
grand total                             4 = 4%
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37729899
Then give this a try, it has both Group Percents, and Percents of the Grand total

JeffCoachman
Inventory3-db.accdb
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37729909
LOL!

Oh!, In all the posts, I forgot you wanted a *chart*...

Gimme a minute...

;-)

Jeff
0
 

Author Comment

by:gigifarrow
ID: 37729953
TotalByLocation: DSum("Quantity","inventory_tbl","Location=" & "'" & [Location] & "'") could you please explain what the "&" does?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37730048
For lack of a simpler explanation...

"&" in VBA is the symbol for "concatenation"

For Example:
1+1=2
1&1=11

"Jeffrey" & " " & "Coachman" = Jeffrey Coachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37730067
Just a (rather forceful) note here.
;-)
Please *Do Not* use Lookup field in your tables (ex Location in the inventory table)
For all the reasons listed here:
http://access.mvps.org/access/lookupfields.htm

But it this case specifically, it wreaks havoc when trying to create your Chart, because the chart will only see the "Value", not the lookup

...stay tuned
0
 

Author Comment

by:gigifarrow
ID: 37730083
ok I wont use lookup tables. Thanks for the advice and help.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37730179
Also don't name all your Primary Keys "ID", this causes confusion when referring to the "ID" field, because every table has this exact same Primary key name.
In the Inventory Table, the Primary Key should be: InventoryID
In the Location Table, the Primary Key should be: LocationID
In the Customer Table, the Primary Key should be: CustomerID
In the SlabMask Table, the Primary Key should be: SlabMaskID
In the QaeVd23AP45 Table, the Primary Key should be:QaeVd23AP45ID
;-)

..Still working on the chart...
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37730400
Try this,...

Charts on last page of report
Inventory3-db.accdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37730453
Note that in order for chats to display correctly, you must open the report in "Print Preview" explicitly.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37730456
Note that in order for chats to display correctly, you must open the report in "Print Preview" explicitly.

should be:

Note that in order for charts to display correctly, you must open the report in "Print Preview" explicitly.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Export  Access Query To Excell 16 45
Access query with left expression 5 29
Error in Rs.MoveNext & Duplication of Record 14 25
Create Form using Wizard 14 32
MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now