Creating Pareto Charts With Microsoft Excel

Written by:  • 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.

Preparing to Get Started

Slide 1 of 11
Preparing to Get Started
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
Initial Table of Data
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

Select Clustered Column
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.

First Chart
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
Make It Look Like a Pareto Chart
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. 

Change Chart Type
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.

Select Line Chart
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
Adding the Final Touches
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
Options for Modifying the Pareto Chart
click to enlarge

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

Select Format Axis
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.

Enter Fixed Values
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.

Format Data Series
click to enlarge
Adjust Gap and Overlap
click to enlarge
After Adjusting Gaps
click to enlarge

Add Title, Colors and More

Slide 8 of 11
Add Title, Colors and More
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
Choose Secondary Axis
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

Format Secondary Axis
click to enlarge
Fix Maximum Value
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.

Pareto Chart With Two Axes
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.


Comments

Showing all 103 comments
 
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
RE: Creating Pareto Charts With Microsoft Excel
Hi<br><br>Awesome post!<br><br>A small suggestion to add formula of cumulative percentage<br><br>E.g. in cell D2=SUM(C$2:C2)/SUM($C$2:$C$20)<br><br>OR<br>=SUM(C$2:C2)<br>format to % data type<br><br>Then, copy by example.
Pankaj2981989 Dec 18, 2011 4:46 PM
RE: Creating Pareto Charts With Microsoft Excel
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
RE: Creating Pareto Charts With Microsoft Excel
Pareto wouldn't have explained it better!!
Vincentchang Nov 7, 2011 5:34 AM
RE: Creating Pareto Charts With Microsoft Excel
i need some one help on this,, thanks
Parvez Khan Oct 11, 2011 9:10 AM
Creating Pareto Charts With Microsoft Excel
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
RE: cumulative percentage
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
cumulative percentage
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
cumulative percentage
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
RE: cumulative percentage
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
cumulative percentage
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
RE: cumulative percentage
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
cumulative percentage
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
RE: Creating Pareto Charts With Microsoft Excel
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
Thanx
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
Pareto Chart
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
Thanks
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
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
Pareto Chart
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
Pareto Chart
Excellent. This was very useful. I couldn't find this info even within Excel Help!
aby mathew May 3, 2010 10:11 AM
thanks
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
RE: Creating Pareto Charts With Microsoft Excel
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
RE: Creating Pareto Charts With Microsoft Excel
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
Pareto
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
Pareto chart
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
RE: Creating Pareto Charts With Microsoft Excel
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
Thanks!
Your directions were great.
Elaine Oct 13, 2009 8:48 PM
Thank you
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
Pareto chart
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
Pareto chart
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
Pareto
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
RE: Creating Pareto Charts With Microsoft Excel
This is excellent work Each step was very clearly explained. Thanks !
LvRCY Jul 9, 2009 11:03 AM
Thanks
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
Pareto Chart
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
 
blog comments powered by Disqus
Email to a friend