Pareto Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JC - 29 Jul 2006 15:27 GMT

Hello All,

I have found many third party applications for creating Pareto charts in
Excel, but does anyone have a simple and effective method for creating them
in the native version of Excel 2003? I'm specifically looking for the
left-to-right sorted histogram (bar chart) with a line graph overlay that
shows the cumulative contribution of each category (bar).

Thanks in advance,

JC

Reply to this Message

Bernard Liengme - 29 Jul 2006 16:03 GMT

Make a column chart of the data
Right click the bars for the cumulative data, click Chart Type and Specify
Line
I will send a file to you private email
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hello All,
>
[quoted text clipped - 7 lines]
>
> JC

Reply to this Message

Ron Coderre - 29 Jul 2006 20:11 GMT

JC

I'm posting this copy of my email text to you so the forum can be informed:

JC

Since the Excel newsgroups frown upon file attachements, I'm sending this
file directly to you.
I created the attached Pareto Plotter for my company (we're big into Paretos).
Just enter the categories and values on the first sheet then click the
[Refresh/Reformat Charts] button.
The file will automatically sort the data and adjust the chart columns and
chart line.

Let me know if you have any questions.

Regards,

Ron
<<

If anyone else is interested in the Pareto Plotter model, just let me know.

***********
Regards,
Ron

XL2002, WinXP

> Hello All,
>
[quoted text clipped - 7 lines]
>
> JC

Reply to this Message

Rate this thread: