Charts

After you’ve analyzed your data, you’ll want to showcase the key findings through charts.

Beginner skills: Tweaking those default settings

How to insert a chart
How to insert a bar chart or column chart.

How to change the chart type
How to change the type of chart you just made (without deleting it and starting from scratch).

How to move a chart to its own sheet
How to move a chart or graph into its own sheet so you have more space to work.

How to create data labels in charts
How to add data labels to your charts, adjust the font and font size of the data labels, and adjust the position of the data labels.

How to remove tick marks and grid lines
How to maximize data-ink ratio by removing distracting gray lines like tick marks and grid lines.

How to create stacked bar charts

How to reverse the order of the categories in your charts

How to fix funny-looking line charts with ‘Switch Row/Column’

How to adjust the units in your chart’s axes

Intermediate and advanced skills

The Dataviz Design Process

dataviz_design_process_7_steps
Start here! The critical thinking skills that underlie effective data visualizations: www.annkemery.com/dataviz-design-process.

Diverging Stacked Bar Charts

How to Make a Diverging Stacked Bar Chart in Excel
 The challenge: www.annkemery.com/diverging-challenge.

The solution: www.annkemery.com/diverging-solution.

Small Multiples Bar Charts

From Data Table to Small Multiples in Under 5 MinutesOption A: Several charts in one: www.annkemery.com/small-multiples-solution.

Option B: A stacked bar chart: www.annkemery.com/data-table-to-small-multiples.

%d bloggers like this:

Related Links:

Togel178

Pedetogel

Sabatoto

Togel279

Togel158

Colok178

Novaslot88

Lain-Lain

Partner Links