Charts

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

My tutorials about charts and graphs include:

Or, watch the entire charts playlist in YouTube.

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 gridlines

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

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


Return to top

Jump to: Excel for Evaluation homepage | Importing and MergingHousekeeping | Cleaning and Recoding | Exploring | Descriptives | Pivot Tables | Charts | Extras | Putting It All Together

5 thoughts on “Charts

  1. Pingback: Dataviz Copycat Challenge: The Answers | Emery Evaluation

  2. Pingback: Evaluation is an Everyday Activity » Blog Archive

  3. Pingback: Dataviz Challenge #3: The Side by Side Bar Chart | Emery Evaluation

  4. Pingback: Dataviz Challenge #3: The Answers! | Emery Evaluation

  5. Pingback: Dataviz Challenge #4: The Answers! | Emery Evaluation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s