Building Pareto Charts - Ordering Chart Data By Count

C

CevinMoses

My bar chart has the following ROW SOURCE:

TRANSFORM Count(*) AS [Count] SELECT [NP_PLATE] FROM [Grading_W-2] WHERE
[SHIFT] = '3' AND [STATUS] LIKE '*F' GROUP BY [NP_PLATE] PIVOT [Potential];

I would like to order the [NP_PLATE] based on thier quantity, now their
name. Each value of [NP_PLATE] is a 4 digit number, but I would like to
order their quantity in order to build a Pareto chart.

See http://en.wikipedia.org/wiki/Pareto_chart for a better description of
what a Pareto chart is. It will help show what I'm looking for.

Thanks,
Cevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Altering Row Source Data for Charts from Form 13
using WhereCondition:= on charts and graphs 1
Formatting Chart for Yes and No instead of -1 and 0 8
Changing the sort/running order on a Chart 0
How to do Pareto Chart? 4
CrossTab Error if data not present 1
Subreport problem with COUNT and GROUP BY 3
Sorting Count Values in Pivot Table (Excel 2007) 1

Top