Lecture Notes: Creating Par Charts in Excel

Introduction

• Speaker: Mark Davis from Optimum Technology Transfer
• Topic: Creating Par Charts in Excel
• Objective: Learn how to create and customize Par Charts to visualize data effectively
• Tool Used: Excel 2016

What is a Par Chart?

• Definition: A sorted column chart
• Purpose: Visualize which elements contribute most to the total sales quickly
• Example Data: Sales figures from various European capitals

Creating a Par Chart from Scratch

1. Initial Setup

   • Delete existing Par Chart if present
   • Place cursor in the sample data

2. Inserting a Par Chart

   • Navigate to the Insert tab in Excel
   • Locate the Charts group
   • Select 'Insert Statistic Chart' and choose 'Paro'

3. Understanding the Par Chart

   • Visualizes the relative proportion of factors to the total
   • Lists cities like Prague, Rome, London with their sales data
   • Easily interprets the most significant contributors

Customizing the Par Chart

1. Basic Adjustments

   • Remove gridlines for a cleaner look
   • Use the Chart Styles button to select a different style

2. Color and Style Modifications

   • Choose a monochromatic color scheme
   • Adjust bar spacing by modifying the Gap Width (e.g., 25% to 30%)

3. Enhancing the Par Line

   • Change color to white
   • Increase thickness for better visibility

4. Final Touches

   • Change the default chart title to a descriptive one, e.g., 'Sales Data by City'

Conclusion

• Outcome: Successful creation of a Paro chart in Excel 2016
• Further Learning: Search for more videos by Optimum Technology Transfer

• End Note: Thank you for attending. Goodbye and take care.