SITEMAP ABOUT
MiC Quality

FREE MODULE Introduction to Statistics

  PROCESS IMPROVEMENT AND SIX SIGMA
ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
FREE TRIAL
:: Online Courses
:: Free Trial
>> Statistics Module
>> Excel Primer
:: Six Sigma
:: FAQ
:: Brochures
:: Licenses
:: Discounts
 
Welcome to MiC Quality
Online Course Instructor
Glen Netherwood
MiC Quality
Online Learning
:: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: INTRODUCTION TO STATISTICS Syllabus    PreviousNext

Excel Chart



When we created the frequency table we ticked the check box to obtain a chart output:

I find the way Excel puts the 'Bin' values below the bars of the histogram confusing. Pass your mouse over the image to see how I prefer it.

spreadsheet

Make sure the chart is selected, right click on it to show the popup menu and left click on 'Select Data':

In the panel that appears select the 'Edit' button under 'Horizontal (Category) Axis Labels' and select the range that shows the preferred values:


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy