Last version published: 14/05/2021 07:57
Publication number: ELQ-51531-2
View all versions & Certificate
Slopegraph in Excel
Excel/PowerPoint template to create Slopegraph to show change between two points in time.
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 Slopegraphs, Range Bar Graphs and Deviation Bar Graphs (both in magnitude and percent) in Excel and PowerPoint to show change between two points in time.
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
Hotel Performance Dashboard in ExcelExcel dashboard to evaluate the historical and forecasted performance of a hotel—compared to that of its competitive set65add_shopping_cart$150.00by Hicham Bou Habib
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.46add_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.90add_shopping_cart$25.00by Hicham Bou Habib
Cycle Plot in ExcelExcel/PowerPoint template to build Cycle Plots, Run Sequence Plots and Graph Envelope Overview to detect seasonality.27add_shopping_cart
One-dimensional Scatterplot with Jitter in ExcelExcel/PowerPoint template to build 1-dimensional scatterplots—with jitter—to show distributions for several categories.37add_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.19add_shopping_cart
Arrow Chart in ExcelExcel/PowerPoint template to create Arrow Charts (Range bar graph) to show change between two points in time.18add_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.12add_shopping_cart$20.00by Hicham Bou Habib
Any questions on Slopegraph In Excel?
The user community and author are here to help. Go ahead!