AronMcD
asked on
MS Access 07 How to create a Pareto Chart in a report
I have successfully created a chart with the following query.
SELECT Sum(TBCSum) AS [Torch/Burn/Clamp Marks], Sum(MissingWelds) AS [Missing Welds], Sum(AirInWeld) AS [Air In Weld], Sum(HoleInWeld) AS [Hole In Weld], Sum(HammerMarks) AS [Hammer Marks], Sum(Rewelds) AS [Re welds], Sum(TackMarks) AS [Tack Marks], Sum(TorchMarks) AS [Torch Marks], Sum(MissPartsProd) AS [Missing Parts Prod], Sum(WBPartsInstalled) AS [Wrong/Bad Parts Installed], Sum(MissPartsEng) AS [Missing Parts Eng], Sum(BurnThrough) AS [Burn Through], Sum(PartsInWrongLoc) AS [Parts In Wrong Location], Sum(Blend) AS [Weld Blend], Sum(Guber) AS [Weld Guber], Sum(Washout) AS [Weld Washout]
FROM WeldFrequency;
I'm basically getting the sum of all the fields in the table. How do I make this into a Pareto chart?
SELECT Sum(TBCSum) AS [Torch/Burn/Clamp Marks], Sum(MissingWelds) AS [Missing Welds], Sum(AirInWeld) AS [Air In Weld], Sum(HoleInWeld) AS [Hole In Weld], Sum(HammerMarks) AS [Hammer Marks], Sum(Rewelds) AS [Re welds], Sum(TackMarks) AS [Tack Marks], Sum(TorchMarks) AS [Torch Marks], Sum(MissPartsProd) AS [Missing Parts Prod], Sum(WBPartsInstalled) AS [Wrong/Bad Parts Installed], Sum(MissPartsEng) AS [Missing Parts Eng], Sum(BurnThrough) AS [Burn Through], Sum(PartsInWrongLoc) AS [Parts In Wrong Location], Sum(Blend) AS [Weld Blend], Sum(Guber) AS [Weld Guber], Sum(Washout) AS [Weld Washout]
FROM WeldFrequency;
I'm basically getting the sum of all the fields in the table. How do I make this into a Pareto chart?
This article relates to 2002 - may also work in 2007
ASKER
I have read that article and wasn't able to get it to work. I'll give it another try I guess.
ASKER
I get to this step: Click the Axis tab. Under Plot series on, click Secondary Axis, and then click OK.
And the it is disabled with Primary Axis selected. I'm not sure what I'm doing wrong.
And the it is disabled with Primary Axis selected. I'm not sure what I'm doing wrong.
ASKER
Any other suggestions? The example in the link doesn't really apply to my situation as I'm not using currency or percentages. And when going through the steps and changing to Number rather than Currency (as they suggest), when I go to change the Plot Series to Secondary Axis it is disabled.
...This is why it is always best to post a sample DB, ...
Does your query produce the series in "Declining" order as is needed for a true Pareto chart?
Is each series the same color or a different color...?
Does your query produce the series in "Declining" order as is needed for a true Pareto chart?
Is each series the same color or a different color...?
ASKER
I'm not sure how to produce the series in Declining order with the query I'm using.
Each Series is the same color.
boaq, I have attached a sample copy of my DB. Let me know if you need anything more.
I appreciate the help.
Database1.mdb
Each Series is the same color.
boaq, I have attached a sample copy of my DB. Let me know if you need anything more.
I appreciate the help.
Database1.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll take a look at it right away tomorrow morning Jeff. Thank you!
;-)
ASKER
Thanks Jeff. I appreciate the help!
...Actually an interesting question...
I'll play around with this for a while in my spare time...
If I come up with anything, ...I'll post it here
I'll play around with this for a while in my spare time...
If I come up with anything, ...I'll post it here