Last version published: 13/04/2021 11:41
Publication number: ELQ-13149-4
View all versions & Certificate
One-dimensional Scatterplot with Jitter in Excel
Excel/PowerPoint template to build 1-dimensional scatterplots—with jitter—to show distributions for several categories.
Acquire consulting license for $10.00
Add to cart
Add to bookmarks
To enable business analysts, scientists, statisticians, data visualizers and journalists to produce one-dimensional scatterplots in Excel to show and compare distributions.
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 set119add_shopping_cart
Dot plot / Dumbbell and Lollipop charts in ExcelExcel/PowerPoint template to create Dot Plots, Dumbbell and Lollipop charts to rank one or two data series.121add_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.256add_shopping_cart
Cycle Plot in ExcelExcel/PowerPoint template to build Cycle Plots, Run Sequence Plots and Graph Envelope Overview to detect seasonality.60add_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.53add_shopping_cart
Arrow Chart in ExcelExcel/PowerPoint template to create Arrow Charts (Range bar graph) to show change between two points in time.63add_shopping_cart
Slopegraph in ExcelExcel/PowerPoint template to create Slopegraph to show change between two points in time.53add_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.55add_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.44add_shopping_cart
Any questions on One-dimensional Scatterplot With Jitter In Excel?
The user community and author are here to help. Go ahead!