Publication number: ELQ-65351-1
View all versions & Certificate
Dot plot / Dumbbell and Lollipop charts in Excel
Excel/PowerPoint template to create Dot Plots, Dumbbell and Lollipop charts to rank one or two data series.
Acquire consulting license for $10.00
Add to cart
Add to bookmarks
To enable business analysts, consultants, scientists, statisticians, data visualizers and journalists to produce Dot plots, Dumbbell and Lollipop charts in Excel and PowerPoint to rank one or two data series.
Exploratory data analysis (EDA), reporting and communication in business, science, statistics, data visualization or data journalism.
Template relies heavily on Excel's Dynamic Arrays capabilities, only available to Office 365 subscribers.
Write a review
People using this Best Practice also downloaded
More Best Practices from Hicham Bou Habib
Hotel Performance Dashboard in ExcelExcel dashboard to evaluate the historical and forecasted performance of a hotel—compared to that of its competitive set105add_shopping_cart
Scatter Plot Matrix in Excel (12x12 panels) with Correlation MatrixExcel template to build a Scatterplot Matrix—with up to 12 variables—in one chart for ease of analysis and formatting.223add_shopping_cart
Cycle Plot in ExcelExcel/PowerPoint template to build Cycle Plots, Run Sequence Plots and Graph Envelope Overview to detect seasonality.57add_shopping_cart
One-dimensional Scatterplot with Jitter in ExcelExcel/PowerPoint template to build 1-dimensional scatterplots—with jitter—to show distributions for several categories.90add_shopping_cart
Bar Chart With Color Ranges In ExcelExcel/PowerPoint template to build a bar graph with color ranges of bars representing another dimension in the data.49add_shopping_cart
Arrow Chart in ExcelExcel/PowerPoint template to create Arrow Charts (Range bar graph) to show change between two points in time.54add_shopping_cart
Slopegraph in ExcelExcel/PowerPoint template to create Slopegraph to show change between two points in time.46add_shopping_cart
Small Multiple of Bar Graphs or Line Charts in Excel (Trellis / Coplot)Excel template to build a Small Multiple of Bar Graphs or Line Charts—in one chart—for ease of analysis and formatting.46add_shopping_cart
Non-ribbon Sankey Diagram in ExcelExcel template to create a Non-ribbon Sankey Diagram used to depict connections between one dataset and another.31add_shopping_cart
Any questions on Dot Plot / Dumbbell And Lollipop Charts In Excel?
The user community and author are here to help. Go ahead!