Creating Pareto Charts With Microsoft Excel

Written by: Michele McDonough • Edited by: Michele McDonough
Updated Sep 20, 2011 • Related Guides: Microsoft | Pareto Chart | Gantt Chart

If you want to make a Pareto chart to use in your project presentation but don’t have access to high-powered project management software, don’t panic. With these step-by-step instructions, you can use the more commonplace Microsoft Excel to create your chart in minutes.

Next up: Initial Table of Data ►

Preparing to Get Started

Slide 1 of 11

click to enlarge

This image shows one example of how your finished Pareto chart may look. The actual appearance will depend on your choices for customization.

A Pareto chart is a tool commonly used in Six Sigma and other project management methodologies to illustrate the root problems or causes of a situation. Although Pareto charts can be easily graphed in several different project management applications, not everyone has access to software of this type. Fortunately, these analysis tools can also be created in Microsoft Excel, and we’ll explain how in this step-by-step guide.

We'll be using Excel 2010 to make our chart, but the same steps work in Excel 2007. You can also use this same technique to create a Pareto chart in older versions of Excel—the tools are just in different locations. Excel 2007 and 2010 both have the "new" Microsoft Office ribbon, while previous versions of the software still use toolbar menus.

Initial Table of Data

Slide 2 of 11

click to enlarge

This table holds all of the data we'll use in our step-by-step walkthrough.

Note: Before getting started, you may also want to take a look at Performing a Pareto Analysis in Excel to get a better idea about how a Pareto chart is used.

To begin, input the data from your project research into a table, which we'll use to create a chart in Excel. This doesn’t have to be a “fancy” table, but it does need to contain information on Count, Percent of Total, and Cumulative Percent as shown in the screenshot above. We actually won’t use the Count column to create the Pareto chart, but it is needed to calculate the other figures so we’re including it in this example. Plus, some people may choose to display the Count instead of the Percent of Total on the chart.

Another Optional Column: In the screenshot, the last column is labeled Horizontal Line Value and 80.00 has been entered for every value. This information will be used to graph a horizontal line at the 80% cut-off mark on the final chart in our example—but it really is completely optional.

First Steps in Chart Creation

Slide 3 of 11

click to enlarge

After the data has been entered into the table, select the columns containing the information related to the Problem, Percent of Total, Cumulative Percent and Horizontal Line Value (optional). If your data is in non-adjacent columns, like in our example here, hold down the Ctrl key in order to select multiple items at once.

With the data still selected, click on the Insert tab of Excel’s main toolbar. From the Charts group on this tab, select Column and then pick the first entry (Clustered Column) of the 2-D Column choices, as shown in the image to the right.

click to enlarge

This initial graph should look like the one shown to the left. It may not look much like a Pareto chart yet, but don't worry! We still have a few adjustments to make to get our formatting right.

Before going on to the next step, you may want to take a few seconds to adjust the size and placement of the chart in the worksheet. While this isn't completely necessary, it may make the components easier to see and work with in later steps. Plus, you can always resize again at the end of the process if you like.

Make It Look Like a Pareto Chart

Slide 4 of 11

click to enlarge

Your Pareto chart should look something like this after following the steps below. Still looking a little ugly? Don't worry, we can make it better.

click to enlarge

The problem with our initial chart above is that everything is graphed as a column, but we want the Cumulative Percent and Horizontal Line Value series to show up as line graphs. So, the next thing we're going to do is fix that real quick.

Right-click on one of the bars representing the Cumulative Percent data. From the options menu that appears, choose Change Series Chart Type. See the figure to the right.

click to enlarge

This option will let us represent the Cumulative Percent data as a line while leaving the Percent of Total as a bar representation. When the Change Chart Type window appears (see left screenshot), choose the first option in the Line category.

After clicking OK, do the same thing for the Horizontal Line Value data, if you chose to include that information in your graph.

Now, things are starting to look a little better. The large image above shows that our graph is finally starting to take on the appearance of a Pareto chart.

Adding the Final Touches

Slide 5 of 11

click to enlarge

While this is an optional step, most Pareto charts don't need a legend.

The Pareto chart we have now is functional, but it still could use a bit of "prettying up." Here are a few additional things we can do—each of these modifications is optional, so just pick the ones that suit you.

Modifying or Getting Rid of the Legend

To change the position of the legend—or to get rid of it altogether—make sure the chart is selected and then click on the Layout tab in the Chart Tools grouping. Click Legend from the Labels grouping, and choose the style you like. For this case, I am going to pick None, because I think the chart is pretty self-explanatory without a legend—and I personally prefer graphs with as little "clutter" as possible.

In the next few slides, we'll discuss some other modifications—including how to add a dual axis—and describe how to make the Pareto chart look more appealing.

Options for Modifying the Pareto Chart

Slide 6 of 11

click to enlarge

Changing the range of values for the y-axis is a quick and easy modification.

click to enlarge

Adjusting the Vertical Axis (y-Axis) Values

By default, Excel chose to extend the values on the vertical axis from 0 to 120. However, our values here are never going to be over 100%, so we can manually change these default values to make a little more sense.

To do this, right-click over the y-axis and select Format Axis (see first image below). In the pop-up window that appears, select the Fixed option for both Minimum and Maximum, entering 0 for Minimum and 100 for Maximum. Click Close when done, and the graph will be updated.

click to enlarge

Now, your Pareto chart should look like the large image shown above.

Note: If you want to use a dual axis so that the cumulative percentage and horizontal line graphs don't skew the look of your graph, go forward to the slide titled Update: Adding a Secondary Axis for Cumulative Percentage.

Move the Columns Closer Together

Slide 7 of 11

Many people also like to adjust the gaps between the columns in the Pareto chart—some even prefer to remove the gaps completely so that all columns "touch."

If you'd like to make this adjustment, right-click on any of the columns and select Format Data Series (see first screenshot below). A new window will appear, allowing you to adjust the Series Overlap and Gap Width values. One nice thing—any changes you make here will show on the chart as you make them, so you can play around a little with the sliders to get a result that looks nice to you. When done, just click Close to return to your chart.

click to enlarge

click to enlarge

click to enlarge

Add Title, Colors and More

Slide 8 of 11

click to enlarge

This is just one sample of the formatting options you can use to make your Pareto chart more visually appealing.

Now, we have a Pareto chart that gives a good representation of our data. All that's left to do is add a title and play around with the various chart formatting options in Excel to spruce up the overall design. This is actually my favorite part of the whole process, since Excel 2010 has a lot of great design tools. Use the options on the Design, Layout and Format tabs of the special Chart Tools grouping to try out a few different looks.

If you'd like to download the data table and Pareto chart created in this tutorial, you can do so at this link: Excel 2010 Pareto Chart.

Want to make the Pareto chart look even better? The next couple of slides will show how to add a secondary axis to the chart.

Update: Adding a Secondary Axis for Cumulative Percentage

Slide 9 of 11

A few people have asked about adding a secondary axis for the cumulative percentage graph so that the entire chart doesn't have to be scaled to 100 percent. Here are the steps for that, starting with the already formatted chart shown in the previous section.

Format Data Series for Cumulative Percentage

click to enlarge

click to enlarge
Step 1: First, right click the cumulative percentage curve and select Format Data Series. This will call up the Format Data Series window. On the Series Options tab, click on the radio button next to Secondary Axis.

Click Close to apply the changes and return to your chart.

Note: If you added the Horizonal Line to your Pareto chart, do the same thing for that graph so that it will also be associated with the secondary axis.

Formatting the Secondary Axis

Slide 10 of 11

click to enlarge

click to enlarge
Step 2: Now, right click on the secondary axis and select Format Axis (see screenshot to the left). In the Axis Options tab of the Format Axis window, change the Minimum and Maximum to Fixed (as opposed to Auto). Enter 0 for Minimum and 100 for Maximum.

Click Close to return to exit this window and return to your main Excel spreadsheet.

Step 3: Similarly, right click on the primary axis and adjust the Maximum value based on the Percent of Total graph. This will vary, depending on your data. For instance, the largest individual percentage in the example I am using is 30.67 percent, so I am going to change the Maximum to 45. You can play around with this option to get the look you like.

click to enlarge

The image to the right shows the new Pareto chart with both a primary and a seconday axis. If you'd like to label these two axes (or apply any other formatting), make sure the entire chart is selected and go to the Layout tab in the Chart Tools grouping. Here, you can label one or both axes—you can also label the horizontal axis if you think doing so would add value to your presentation.

Additional Resources: There are several other Excel project management templates available in the Media Gallery, including this collection of Six Sigma layouts. You can also find step by step instructions for creating a Gantt chart in Excel here on the Project Management Channel. Feel free to download any of these materials and modify them to fit your own project needs.

If you have any other questions or suggestions, please leave a note in the comments!

If you're looking for more sample forms and downloadable templates, check out Bright Hub's resource guide: Over 50 Free Project Management Templates and Sample Forms.

References

Slide 11 of 11

Microsoft Excel Official Site, http://office.microsoft.com/en-us/excel/
All screenshots taken by author.

◄ ●●●●●●●●●●● ►

lm Jan 31, 2012 4:30 AM

RE: Creating Pareto Charts With Microsoft Excel

I can't thank you enough! I owe my A to you.

Leathergloves Dec 27, 2011 8:26 AM

Hi Awesome post! A small suggestion to add formula of cumulative percentage E.g. in cell D2=SUM(C$2:C2)/SUM($C$2:$C$20) OR =SUM(C$2:C2) format to % data type Then, copy by example.

Pankaj2981989 Dec 18, 2011 4:46 PM

can anybody tell me how to make a pareto analysis by using mini tab? plz tell me my email i.d is pankaj2981989@gmail.com

Jess Dec 6, 2011 2:48 PM

Pareto wouldn't have explained it better!!

Vincentchang Nov 7, 2011 5:34 AM

i need some one help on this,, thanks

Parvez Khan Oct 11, 2011 9:10 AM

Tanks Michele,
Really u helped me to simplify making PC.

THANKS

nathaniel Sep 22, 2011 12:38 PM

Parato Analysis

Many thanks, found the tutorial easy to follow and very useful

Michele McDonough Jul 2, 2011 8:03 PM

RE: Victor.tam

Hi Victor, thanks for checking out the article! Many of those questions can be answered in other articles here at Bright Hub. For Six Sigma info, take a look at the articles in the corresponding topic. Also, there are tutorials for how to create several other charts and graphs in our Software Reviews & Tips category.

Michele McDonough Jul 2, 2011 8:01 PM

RE: Secondary Axis for % Error

To add a second axis, right-click the data series, choose Format Data Series and choose the Secondary Axis option. I agree -- this option really seems buried and hard to find in Excel 2007 and 2010!

Also, great ideas for things to add. I'll see about working those in on the next update.

Victor.tam Jul 2, 2011 11:45 AM

How can I make a pareto chat in Excel 2007?

Hi,

I have a one question for making the chat, because I am a new one in Excel 2007, we used to made the chat by Excel 2003, but I am not sure I can understand after the step by step, also I don't understand what is the six sigema. because I am working for quality DEPT. so I have to learn some chats in my career. so, could you please teel me what is the six sigema and how can I creat more chats in Excel 2007(for example,fish bone & something like that ). thank you!

Martin Jun 30, 2011 1:44 PM

Secondary Axis for % Error

Your post was very helpful. I'm an OLD Excel user and am so frustrated with the new Excel and how it has been dumbed down. Where is the Dual Axis Graph option that used to be standard and made plotting Pareto Charts so easy? One thing you should add to your instrudtions is how to creat the secondary axis for cumulative percentage. This will make the chart more usable when small percentage categories are identified, so they don't all scale to 0-100. Also good when OCCURANCES are used as the counting method rather than % of the total error (i.e. Problem 1 occurred 10000 times, problem 2 occurred 8876 times, etc. and trying to graph that against a 0-100% contribution line.

CrankyOtter Jun 30, 2011 12:43 PM

Change Series Chart Type

To anyone who used old Excel and just chose the existing "bar plus line graph" chart template that got removed in the not-helpful update: This option "change SERIES chart type" is how you make the change. Yanno, this used to just be available without all the digging around.

Michele McDonough May 29, 2011 11:20 AM

RE: how to make Pareto for this

Hmm, I'm not sure that type of data translates well to a Pareto chart. A Pareto chart is more for when you have a list of several causes that are all leading to the same problem.

yash pal May 29, 2011 5:53 AM

how to make pareto for this

hi,

how to make pareto for when the data is given in percentage (for example i have call to 114 customer out of which 45 says the vehicle problem is satisfactory and 45 percent says that their problem fixed first time right, 65 percent says washing quality is ok)

Michele McDonough May 19, 2011 3:15 PM

RE: cumulative percentage

Not quite sure what the problem might be without seeing the spreadsheet, but these two chart types can be definitely used together. Is it just the horizontal line that is causing the problems?

jithin May 18, 2011 9:07 AM

cumulative percentage

no...didnt do anythin different.. at first i didnt include the horizontal line values..only that one.

Michele McDonough May 18, 2011 7:38 AM

I'm not sure why you are getting that error, you can definitely plot these chart types on the same graph. Are you doing anything differently this second time around?

jithin May 18, 2011 2:06 AM

its showing like "some chart types cannot be done on the same chart"... i dont have any idea why it is like this

jithin May 18, 2011 1:52 AM

ok..now i got it..
now i am facing so many problems while making a pareto chart..i have made one earlier..now when i'm trying to make again..i'm not able to do it.

Michele McDonough May 17, 2011 10:52 PM

Yes, many would stop at the "changed mind" reason because it is so close to 80%, but some others would also include the next category "too complicated" to make sure at least 80% were covered.

jithin john kovoor May 17, 2011 10:58 AM

thanks michelle for the reply.
so in the example we are concerned till the changed mind section right..

Michele McDonough May 16, 2011 12:00 PM

Hi Jithin,

When doing a Pareto analysis, we generally look at the problems that account for 80% of the problems. So, we use the cumulative percentage to help find that 80% point -- sometimes it is a little more or a little less, but the cumulative percentage line can be used to find that collection of issues that 80% of the problems result from. In this case, it was pretty easy to see because we only had a small set of "causes" on our chart, but in larger cases, the cumulative percentage line is very helpful.

For more info, take a look at http://www.brighthub.com/office/project-management/articles/65152.aspx

Thanks!
Michele

Jithin John Kovoor May 16, 2011 10:40 AM

hello...
i am new to this pareto chart thing. and for me it was very easy to understand how to make one. but i didnt understand why we are calculating the cumulative percentage or the cumulative line.
hope i will get a reply for this

thanks
jithin

Michele McDonough May 13, 2011 8:36 PM

RE: How to draw Pareto by using Excel 2003

I don't have a copy of Excel 3 to check for the location, but there should be an option to change the min and max values on the y-axis to 0 and 100, respectively. Does that work for you?

duong May 13, 2011 5:14 AM

How to draw Pareto by using Excel 2003

I have drawn Pareto by Excel 2003, but the value 0% was not at 0 position. Can you tell me how to do it.
Thank for your time.

Arun Mar 22, 2011 6:44 AM

Pareto Chart

Thanks a lot. Pretty cool!

Victor Mar 18, 2011 5:19 AM

Excellent

very straight forward to understand

mayur Mar 15, 2011 8:12 AM

pareto

good exercise

Rajat Rahul Mar 10, 2011 2:00 AM

Thanking Message

Wishing u thx a lot for this incredable docs..

Rajesh Sharma Jan 4, 2011 11:12 PM

Thanx

thanx a lot for posting such a simple method to understand this......

pritam palkar Jan 2, 2011 3:38 PM

excellent...

Basharat Andrabi Dec 16, 2010 3:20 AM

Thanks

Best ever topic which is so clear and easy to understand.

Hats off to you Michelle.

Regard,
Basharat

Maninder Dec 7, 2010 1:45 AM

thanks

I have to need the pareto chart software. can you provide me the same

Ajith Nov 12, 2010 4:23 AM

Thanks 4 d post............

Kathi Nov 9, 2010 5:29 PM

awesome!!

Your directions were SO easy to understand. Thanks for posting.

Sarika Sep 28, 2010 4:08 PM

Hi that was very simple and comprehensive.

Thanks

rudresh K v Aug 25, 2010 4:26 AM

Please suggest a book

Please suggest for Excel operations

Trinh Van Truong Jul 28, 2010 2:56 AM

Create Secondary Axis

Thanks You

You can to create secondary Axis in chart below:
right-click a one bar in chart, and select the 'Format Data Series...', next 'Series Option", next 'Secondary Axis, complete.
(it is very good when use Quantity Total more than 100)

Shylajasubramanian Jul 19, 2010 8:05 AM

It is very simple way to understand........ Thanks

Manish Jul 18, 2010 11:29 PM

Simple & Best

I really appreciate the method of explaining and teaching on Pareto chart. Thanks to entire team who worked for it.

Magesh Jul 17, 2010 7:20 AM

simple way of teaching

Dear michelle,

It was very simple to learn.

Deepak Jul 14, 2010 11:28 AM

Thanks a ton!!!

Dear michelle,

This was one of the most helpful article i ever read.....people like you make world wide web all the more worth referring to learn and understand....

regards
deepak

Krishna Jun 29, 2010 4:23 AM

Thanks a lot and this was very useful

Reggie Jun 29, 2010 4:10 AM

THANKS

Thanks. Very useful and simple explanation to draw the Pareto chart. Am doing some assignment and was required to draw a pareto chart and I just completed drawing the pareto chart. Thanks Michelle for your very clear explanation and sample.

Lay-Z Jun 23, 2010 9:59 AM

Analysis tool pak

the analysis tool pak does it for you (if you're lazy like me); but if you like the long tedious route that microsoft almost always requires to do something simple, this is a good guide. props.

Donna Jun 14, 2010 4:05 AM

Hi Michelle, I need your assistance. I have worked through the steps given but somehow am not getting the plotted cumulative line.

ELOY Jun 13, 2010 7:07 PM

ELOY

Como diria Pareto molto grazie Michele por su ayuda me hacia falta para hacer mi informe de ingenieria.

Gracias................ un amigo de Peru..... ELOY

Toncan Jun 9, 2010 10:01 PM

Pareto Analysis

This tutorial is very helful to me in completing my assignment. Thanks with much appreciation.

Masiye Mangwana May 9, 2010 9:26 AM

Pareto analysis

I am for BWB and i have been given an assignment to redesign any process. I have chosen a new water connection process. I have been asked to identify bottle necks during the process and these should be presented on the pareto chart. I am failing to present them on the pareto chart, please assist because i have tried to follow the instructions but some way i am lost.

Masiye

Nyberg05 May 9, 2010 1:18 AM

Much Appreciated

I've used this several times now. Thanks for publishing such a helpful and easy to follow post!

Joe May 8, 2010 2:45 PM

That was too easy!

You should write help files for Microsoft! Not only did I find something I needed, I learned something new about graphs in Excel.

Ravi May 6, 2010 7:24 PM

Excellent. This was very useful. I couldn't find this info even within Excel Help!

aby mathew May 3, 2010 10:11 AM

michele,
thanks .. u r a star. great help.

yousuf Apr 23, 2010 1:38 PM

pareto chart

thank you michelle, it is really very easy to create a pareto chart on excel 2007. and the way you explain very clear.
thanks

mal Apr 10, 2010 2:25 PM

creating pareto charts

thank alt......
it was a great n so useful to all f us. thanks again and again...

wish you all the best.......................
thanks dear......

Lusi Apr 7, 2010 11:59 PM

Creating Pareto Chart Using Microsoft Exce 2007

Wow! THis article has surely been a lifeline. I have been wodering for some time how to get a soft copy drawn through Excel 2007.

Thanks so much

Muhammad Apr 5, 2010 4:22 PM

thank you very much

thankx alot that was very helpful, May allah rewards you with good.

Hem Mar 29, 2010 2:08 AM

Great explanation - Hem

dgarner Mar 22, 2010 8:49 AM

This was awesome!

So very easy to understand! I knew nothing about Pareto analysis prior to this article. This was much more simpler than I thought it would be! Thanks.

waleed Mar 1, 2010 2:48 PM

Gr8

Thanks a lot.. so useful for me and its sooooo clear

student Feb 26, 2010 5:07 AM

THanx!

this helped me loads of time!! I always open it up whenever i am trying to do a pareto chart! great work!

Preeti Feb 16, 2010 12:39 AM

Pareto

Thanks for sharing this.... :)

keerthi Feb 8, 2010 3:11 AM

Pareto chart

It was really very easy. thank u soo much

malik Feb 4, 2010 11:51 AM

hai, nice explanation very useful.

zion Jan 28, 2010 8:06 AM

CREATING A PARETO CHART USING MICROSOFT EXCEL 2007

Wow! that was great.good job! It was so easy to follow

Kanika Jan 27, 2010 2:44 AM

I am still confused , because the one i learnt long back should have number of errors or anything in ascending order and then cumulative of that and then the percentage ......

raja.n.v Jan 24, 2010 4:13 AM

thank you

the explanation is too good

Hoda Jan 23, 2010 12:30 AM

Thank you

Nice Job

Vijay Jan 22, 2010 1:35 AM

Detailed and Crisp

Nice explanation and guidance

Prem Jan 13, 2010 12:57 AM

Thanks a lot, helded me a lot

Prasad Dec 31, 2009 8:09 AM

parato charts

soooooooooooooooo thanks to ease made of excel based Pareto charts.

Val Hernandez Dec 25, 2009 4:16 PM

Good work! Thank you. It really helped me a lot.

Sam Dec 15, 2009 11:44 AM

Kudos!

Thanks Michelle, you are much more helpful that MS Office Excel 2007. Now back to work.

Dr. Huma Dec 12, 2009 1:25 PM

Thanx alot

That's really helpful and very clear.

shwez Dec 9, 2009 12:51 AM

Thanks!

That was of a great help for me today! I had to urgently present an analysis to my team and this saved me from asking anyone.....
It was simple and easy to follow.

Alan Dec 8, 2009 3:17 PM

Pareto in Exel

Thank you so very much - an idiot guide, for people like me! Saved me having to ask anyone at work.

uma Dec 7, 2009 12:04 PM

thnxx

that was of gr888888 help thnx very much

alisha Nov 30, 2009 11:54 AM

real cool

this was sooooooooooo gud.. my presentation is later an u saved me..dint kno d underground of excel tanks again alot

Martijn van Brandevoort Nov 3, 2009 3:44 AM

Dual axis

If you want the occurences of reasons in absolute numbers and not percentages, you can put the percentage line on the secondary axis (by right clicking -> format axis -> secondary axis). You then get a classic dual-axis Pareto chart.

Konan Nov 1, 2009 11:51 AM

Really thanks a lot

Hi Michele, I'm from Ivory Coast and got some issue with my minitab while urgent work had to be done with pareto chart , so that find your instruction very very very helpful, and use same for my work as well.
thanks a lot.

Anbu Oct 30, 2009 5:40 AM

in MS Excel 2003 & 2007 Plz

Gr8 work, plz submit more of your work on the analysis area. If it would have been common for all Office 2003 & 2007 it will great as many offices didnt upgrade to MS Office 2007. Anyways I tried this tuto in my excel2003, it works great!

JORGE Oct 23, 2009 5:43 PM

JHASON

A QUESTION, TO THERE BE NO VERSION TRANSLATED INTO THE SPANISH?
THANKS

Lindsay Oct 18, 2009 11:31 PM

Your directions were great.

Elaine Oct 13, 2009 8:48 PM

This was really helpful, and I got to use this for an assignment instead of having to draw the pareto chart.

Cnotta Oct 5, 2009 3:44 PM

Very nice indeed.

Simple, Easy to follow. Works with Excel 2007. Thank you.

julian Oct 2, 2009 1:26 PM

Thank you very much....nice and simple explanation...helped me to complete my assignment.

Kristen Bayerl Sime Sep 24, 2009 11:19 PM

Great instructions!

Simple instructions! Produced a perfect Pareto! Thank you!

Bibek Sep 20, 2009 10:26 PM

Thanks a lot !

The instruction was very helpful. You can not imagine how useful it was to me .My gratitude.

Ness Sep 10, 2009 1:58 AM

Thanks!!

Thanks! The instructions were easy to understand and very helpful. :)

Vaseem Khan Sep 8, 2009 10:34 AM

Excellent Simplicity

Hi Michele,
You kept it simple and straight explanation.
It was an excellent to do steps

Henry Aug 14, 2009 3:02 AM

Good training Aids

Nice instruction!

Alexander Jul 31, 2009 12:26 PM

Thanks a lot!!!!
I had a presentation at work and you saved my neck.
Thanks!!

Cory Jul 29, 2009 5:47 PM

Suggestion

This helped a lot thanks. I have a suggestion, however. I think it would be even more accurate if you added a secondary y-axis for the percentage data. It explains how here: http://office.microsoft.com/en-us/excel/HP012341651033.aspx

Hopefully that helps. Thanks for the great post!

LP Jul 28, 2009 11:45 AM

Thank you!

Fantastic tutorial...this helped immensely!

Paul S Jul 27, 2009 4:35 PM

Yu´re awesoMichele . Nice Shot!!

Felipe Jul 23, 2009 11:35 AM

I love it Michele

Thanks for this Michele, AWESOME !!!

canistan zacharias Jul 19, 2009 2:53 PM

Creating Pareto Charts with Microsoft Excel 2007

Easy To understand. Excellent. Thanks a lot Michele.

Frances Jul 16, 2009 3:37 PM

Pareto Charts Explained

Thank you very much... I've been struggling for 2 days with the concept of a Pareto chart and your instructions made it very clear what I was doing wrong. You are awesome!

s Jul 13, 2009 9:59 AM

This is excellent work Each step was very clearly explained. Thanks !

LvRCY Jul 9, 2009 11:03 AM

Good work! Thanks for this. Even managed to work back and get it going in Excel 2000.

Jeanne Jun 25, 2009 8:17 AM

Pareto chart how-to

Thank you for the easy instructions on how to create the Pareto. I knew the steps were in there somewhere, but you laid it out very clearly.

Affandi Ahmad Jun 23, 2009 5:44 AM

This guides is very good and useful.
Thank you very much to Michele on her hard work.
She has done a very good job in putting all info accordingly.
Thanks again for your kind assistant. Really appreciate it.

Vivek Jun 15, 2009 10:15 AM

thankiew

your post did help me alot!
my appreciation and gratitude is at yours.

Cheers

Creating Pareto Charts With Microsoft Excel

Preparing to Get Started

Initial Table of Data

First Steps in Chart Creation

Make It Look Like a Pareto Chart

Adding the Final Touches

Options for Modifying the Pareto Chart

Move the Columns Closer Together

Add Title, Colors and More

Update: Adding a Secondary Axis for Cumulative Percentage

Formatting the Secondary Axis

References

Comments