• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help With Pareto Chart

Bostbrother

New Member
I have built a Pareto Chart with a dual axis. My Pareto line is based on the accumalative % and looks similar to the one I saw in Wikipedia and on the Pareto Chart template this website offers. Sadly, my boss wants the Pareto line to start at the top of the bar of my first data element. I would object, but the same Wikipedia article on "Pareto Chart" shows it done both ways.


Is anyone familiar with Pareto Charts and how to manipulate the second axis? I have played around in the format axis (axis options) but to be honest I don't have a clue what I am doing in there. Trial and error is not working. Any help is greatly appreciated.
 
Dont have your cummulative line start at 0, have it start at the value of Column 1

Otherwise can you post your file somewhere

refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Back
Top