statistics
Faris69
9.CreatingChartsinExcel.pptxSelect the Insert tab.
Highlight the data.
Click on chart type, then subtype.
Use Chart Tools to customize.
Creating Charts in Microsoft Excel
Excel distinguishes between vertical and horizontal bar charts, calling the former column charts and the latter bar charts.
A clustered column chart compares values across categories using vertical rectangles;
a stacked column chart displays the contribution of each value to the total by stacking the rectangles;
a 100% stacked column chart compares the percentage that each value contributes to a total.
Column and bar charts are useful for comparing categorical or ordinal data, for illustrating differences between sets of values, and for showing proportions or percentages of a whole.
Column and Bar Charts
Example 3.2: Creating a Column Chart
Highlighted Cells
Highlight the range C3:K6, which includes the headings and data for each category. Click on the Column Chart button and then on the first chart type in the list (a clustered column chart).
Example 3.2: Creating a Column Chart
To add a title, click on the first icon in the Chart Layouts group. Click on “Chart Title” in the chart and change it to “EEO Employment Report—Alabama.” The names of the data series can be changed by clicking on the Select Data button in the Data group of the Design tab. In the Select Data Source dialog (see below), click on “Series1” and then the Edit button. Enter the name of the data series, in this case “All Employees.” Change the names of the other data series to “Men” and “Women” in a similar fashion.
Line charts provide a useful means for displaying data over time.
You may plot multiple data series in line charts; however, they can be difficult to interpret if the magnitude of the data values differs greatly. In that case, it would be advisable to create separate charts for each data series.
Line Charts
Example 3.3: A Line Chart for China Export Data
Pie Charts
A pie chart displays this by partitioning a circle into pie-shaped areas showing the relative proportion.
Example 3.4: A Pie Chart for Census Data
Pie Charts
Data visualization professionals don't recommend using pie charts. In a pie chart, it is difficult to compare the relative sizes of areas; however, the bars in the column chart can easily be compared to determine relative ratios of the data.
If you do use pie charts, restrict them to small numbers of categories, always ensure that the numbers add to 100%, and use labels to display the group names and actual percentages. Avoid three-dimensional (3-D) pie charts—especially those that are rotated—and keep them simple.
An area chart combines the features of a pie chart with those of line charts.
Area charts present more information than pie or line charts alone but may clutter the observer’s mind with too many details if too many data series are used; thus, they should be used with care.
Area Charts
Example 3.5: An Area Chart for Energy Consumption
Scatter charts show the relationship between two variables. To construct a scatter chart, we need observations that consist of pairs of variables.
Scatter Charts
Example 3.6: A Scatter Chart for Real Estate Data
A bubble chart is a type of scatter chart in which the size of the data marker corresponds to the value of a third variable; consequently, it is a way to plot three variables in two dimensions.
Bubble Charts
Example 3.7: A Bubble Chart for Stock Comparisons
Stock chart
Surface chart
Doughnut chart
Radar chart
Miscellaneous Excel Charts
Many applications of business analytics involve geographic data. Visualizing geographic data can highlight key data relationships, identify trends, and uncover business opportunities. In addition, it can often help to spot data errors and help end users understand solutions, thus increasing the likelihood of acceptance of decision models.
Companies like Nike use geographic data and information systems for visualizing where products are being distributed and how that relates to demographic and sales information. This information is vital to marketing strategies.
Geographic mapping capabilities were introduced in Excel 2000 but were not available in Excel 2002 and later versions. These capabilities are now available through Microsoft MapPoint 2010, which must be purchased separately.
Geographic Data
