Formatting the Secondary Axis
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.
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.