CGS Chapter 3
What are the differences between a bar chart and a column chart?
- A Bar chart compares values across categories in a horizontal orientation. Values are indicated by the length of the bars. - A Column chart compares values across categories in a vertical orientation. Values are indicated by the height of the columns.
What are the differences between a column chart and an area chart?
- A Column chart compare values across categories in a vertical orientation. Values are indicated by the height of the columns. - An Area Chart Displays trends over time or by category. Values are indicated by the filled areas below the lines.
How do pie charts differ from doughnut charts.
- A Pie chart compares the contribution each value in a single numeric data series makes to the whole, or 1 00%. Values are indicated by the size of the pie slices. - A doughnut chart compares the contribution each value in multiple numeric data series makes to the whole, or 100%. Values are indicated by the size of the doughnut segments.
Tufte's five data graphics principles.
- Above all else, show data - Maximize the data‐ink ration, within reason - Erase non‐data ink, within reason - Erase redundant data ink, within reason - Revise and edit
\What are the three steps involved in using the INSERT tab to create a chart?
- Select data you wish to display within the chart - Click insert tab - Click a button in charts group or dialogue box launcher
How many standard chart types and sub-types are available in Excel?
10 standard charts & 53 sub‐types
How do the 100% stacked charts differ from stacked charts?
100% stacked charts show the contribution of each category expressed as a percentage of the total, whereas a normal stacked chart simply adds the numerical value, disregarding any total or proportion.
How does a radar chart differ from other charts?
A Radar chart compares values across categories in a circular orientation. Values are indicated by the distance from a center point. Use it when comparing categories that are not directly comparable (Apples & Oranges).
Give an example of a low data-ink ratio in a chart.
A column or bar chart are examples of low data‐ink ratio charts because they use a large amount if ink within the bars to display a small amount of data.
What are the differences and similarities between a line chart and an X Y (Scatter) chart?
An XY chart compares two numerical values whereas a line chart places numerical values against text labels. Basically, an XY chart only contains value labels, whereas a line chart contains one set of text labels and one set of value labels. Graphically, the charts are very similar in style.
Define a bubble chart and explain what type of data is suitable for plotting on a bubble chart
Bubble Compares sets of three values. The third value is indicated by the size of the bubbles (filled circles). Use this type of chart when comparing the sizes of values.
When should you use a dashboard chart?
Dashboard charts should be used when desiring a quick, visual summary of performance indicators.
What charting limits does Excel have in terms of data points and series?
Excel charts require at least one numeric data series and at least one label data series, and the data series is only limited by available computer memory.
What chart sub-types are available for the stock chart in Excel?
High‐Low‐Close Open‐ High‐Low‐Close Volume‐ High‐Low‐Close Volume‐Open‐ High‐Low‐Close
How do you change the chart type of an existing chart?
Select desired chart Go to the design ribbon and click change chart type Choose type or subtype if necessary and click OK
How do sparklines differ from charts?
Sparklines: These small word‐sized charts or graphics are embedded within the words, numbers, and images they represent. *Sparklines use less "ink"*
Explain how you interpret the data markers on each of the sub types.
The data markers represent the opening & closing price, the highest & lowest price, the decrease & increase in stock value.
Explain the difference between data points in a line chart and an X Y (Scatter) chart.
The data points in an X Y chart are positioned on the chart based on the respective numerical values on each axis. The data points in a line chart, in contrast, are located based on their categorical value on the x‐axis, and their numerical value on the Y axis.
When should you use a line chart vs. an XY (scatter) chart?
The use of an XY chart is necessary when comparing two sets of numerical values. The use of a line chart is important to emphasize a trend over time.
When should you use a 100% stacked line, column, or area chart?
These charts can be used as a substitute for the pie chart. They are able to show how much each value contributes to the total.
When should you use a stacked line, column, or area chart? How do the stacked charts differ from regular charts?
These types of charts should be used when showing the total values for categories within a chart. Stacked charts will show the aggregate amount of all data for that category, stacked upon one another.
