You are viewing a public preview
Sign in to save your progress, do assignments, join discussions and get feedback.
Appearance and formatting; colors, size and display options; data labels, titles, subtitles and fonts; axes, scales, number formats and grid lines; sorting, filtering, Top N and grouping; legends, tooltips and reference lines; layout, readability and accuracy checks.
Learning outcomes
The lecture slides for this lesson are being prepared and will be added here.
Build comparison, trend, composition, relationship and geographic charts from the practice data; then refine their formatting, axes, labels, filters, sorting, legends and tooltips, and check each chart for readability and accuracy. (About 24 hours of independent study.)
By the end of this lesson you can:
Key idea: A first chart answers the question for you; a refined chart answers it for your audience. Every formatting choice should make the main message faster to see and harder to misread.
Most formatting is done in the Format pane (right-click an element and choose Format), and workbook-wide fonts and lines can be set once under Format → Workbook.
Before sharing, ask: Is the message clear in five seconds? Do bar axes start at zero? Do totals match the data? Is anything left that could be removed?
Refine a chart of Profit by Sub-Category (course dataset) for a category manager.
<Sub-Category>: profit <SUM(Profit)> on sales of <SUM(Sales)>.Flashcards · Chart Refinement
9 wordsThe panel for formatting fonts, shading, borders, lines and numbers of a view or workbook.
Dialog for setting an axis range (automatic, uniform, independent, fixed), zero, scale and title.
A measure's number format set once in Default Properties so every view uses it.
A dimension filter that keeps the top or bottom N members by a measure.
A filter applied before Top N, sets and FIXED LOD expressions; shown as a grey pill.
A new dimension that combines selected members into a higher-level category.
The text shown when hovering over a mark; it can be edited and include fields or a chart.
A line from the Analytics pane marking a constant, average, median, min or max.
A title that includes field or parameter values so it updates with filters.
Take the charts from Lab 3A and make them presentation-ready.
Swap your refined charts with a classmate and check each other's against the design principles in Module 1: is the message clear in five seconds?