[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.22″ custom_padding=”54px|0|54px|0px|false|false”][et_pb_row admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”30.7125px|0px|30.7125px|0px”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.4.8″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|6px|5px||”]

Collection

How to Build Data Visualizations in Excel

When I show people a dot plot, the first thing they say is “Cool, but how do I make that?” and this page has all your answers. From time to time I publish blog posts with step-by-step directions on how to make amazing visualizations right inside Excel and I’ve collected those instructions for you right here.

You’ll find more chart choices with updated instructions on how to make them – AND my Quantitative Chart Chooser – in my book, Effective Data Visualization.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”30.7125px|0px|30.7125px|0px”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/Dotplotfinal.png” url=”http://evergreen.letsaweso.me/easy-dot-plots-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Dot Plot

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/HDumbbellThumbnail.png” url=”https://stephanieevergreen.com/horizontal-dumbbell-dot-plots-easier/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Horizontal Dumbbells

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/verticaldumbbellthumbnail.png” url=”http://evergreen.letsaweso.me/dumbbell-dot-plot/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on” border_color=”#d4d8db”]

Vertical Dumbbells

 
[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”30.7125px|0px|30.7125px|0px”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/Overlapping4.png” url=”http://evergreen.letsaweso.me/overlapping-bars/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Overlapping Bars

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/DivergingFinal.png” url=”http://evergreen.letsaweso.me/diverging-stacked-bars/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Diverging Stacked Bar

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/benchmarkthumbnail.png” url=”http://evergreen.letsaweso.me/adding-a-benchmark-line/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Benchmark Line

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”30.7125px|0px|30.7125px|0px”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/Lollipopthumbnail.png” url=”http://evergreen.letsaweso.me/lollipop/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Lollipop

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/slopethumbnail.jpg” url=”http://evergreen.letsaweso.me/slopegraph/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Slopegraph

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/rankthumbnail.png” url=”http://evergreen.letsaweso.me/ranking-data-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on” border_color=”#d4d8db”]

Ranking Data

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”30.7125px|0px|30.7125px|0px”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/pictothumbnail.png” url=”https://stephanieevergreen.com/make-a-pictogram-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on” border_color=”#d4d8db”]

Pictogram

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/backtobackthumbnail.png” url=”http://evergreen.letsaweso.me/making-back-to-back-graphs-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Back to Back

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/bulletthumbail.jpg” url=”http://evergreen.letsaweso.me/easiest-bullet-charts-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Bullet Chart

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”30.7125px|0px|30.7125px|0px”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/databarsthumbnail.png” url=”http://evergreen.letsaweso.me/easy-bullet-charts-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Data Bars

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/sparklinethumbnail.png” url=”http://evergreen.letsaweso.me/dashboard-icons-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Sparklines & Indicators

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/smmultlinesthumbnail.png” url=”https://stephanieevergreen.com/super-fast-small-multiples/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on” border_color=”#d4d8db”]

Small Multiple Lines

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”30.7125px|0px|0|0px|false|false”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/dotandbarthumbnail.png” url=”http://evergreen.letsaweso.me/adding-confidence-intervals-to-a-dot-plot/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on” border_color=”#d4d8db”]

Confidence Intervals

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/standarddeviationthumbnail.png” url=”http://evergreen.letsaweso.me/adding-standard-deviation-to-a-dataviz/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on”]

Standard Deviation

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/04/horizontaldumbbelloldthumbnail.png” url=”http://evergreen.letsaweso.me/how-to-make-dumbbell-dot-plots-in-excel/” url_new_window=”on” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”3.23″][/et_pb_image][et_pb_text _builder_version=”3.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” module_alignment=”center” custom_margin=”|||” custom_padding=”10px|5px|5px|5px” border_color_all=”#d4d8db” use_border_color=”on” border_color=”#d4d8db”]

Horizontal Dumbbells (Old)

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_4,1_4″ _builder_version=”3.25″][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2020/07/academy_badge_text.png” title_text=”academy_badge_text” url=”https://academy.stephanieevergreen.com/” url_new_window=”on” _builder_version=”4.4.8″ hover_enabled=”0″ align=”right”][/et_pb_image][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.4.8″]

Learn in the Academy!

You can find step-by-step video instructions on how to make 60+ awesome visuals in Excel, Tableau, and R through my Evergreen Data Visualization Academy.

Enrollment opens to a limited number of students only twice a year. Get on the wait list to be notified of our next enrollment window. Come join our super supportive community.

[/et_pb_text][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_image src=”https://stephanieevergreen.com/wp-content/uploads/2016/06/GGLogo.png” title_text=”GGLogo” url=”https://academy.stephanieevergreen.com/the-graph-guide-program/” url_new_window=”on” _builder_version=”4.4.8″ hover_enabled=”0″ align=”right”][/et_pb_image][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.4.8″]

Master Viz with Graph Guides!

Our newest program, Graph Guides, is a custom-built, year-long sprint through 50 Academy tutorials, based on an assessment of your current data viz skill set.

We only open enrollment to 12 students at a time. Get on the wait list for a heads up about your next chance to gain a competitive edge. Your Graph Guide will hold your hand as you blaze your way to new talents.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.22″][/et_pb_section]