Animated Speedometer Chart in Excel with VBA (Step by Step)
An animated speedometer chart in Excel does more than show a KPI: when the value changes, the coloured arc sweeps up from zero, the needle travels with it and the
Charts and Visualization
In this category, you will find comprehensive tutorials on creating stunning charts and visualizations in Excel. Impress your colleagues and boss with attractive and informative visuals by following our step-by-step guides. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the process. Explore this category now and enhance your data analysis and presentation skills with Excel.
Dynamic Variance Arrows Chart with Slicers in Excel
A dynamic variance arrows chart with slicers compares this year with last year month by month, draws a green up arrow or a red down arrow over each pair of
Dynamic Variance Arrows Chart with Check Boxes in Excel
A dynamic variance arrows chart with check boxes shows this year against last year for every month and puts a green up arrow or a red down arrow on top
Group of Circle Charts in Excel: KPI Doughnut Infographic
A group of circle charts in Excel shows one headline KPI and its breakdown in a single, dashboard-ready picture. In this tutorial you build one for service level: a large
Dynamic Chart with Scroll Bar in Excel: Form Control Method
A dynamic chart with scroll bar lets you show a long daily data set in a small, readable chart: drag the scroll bar and the chart slides forward or back
Word Cloud in Excel Using VBA (Free Download)
A word cloud in Excel using VBA turns a simple two-column list into an eye-catching visual where every word is sized by its value. Word clouds, also called tag clouds
Forecast vs Actual Chart with Safe Zone Range in Excel
A forecast vs actual chart with a safe zone range in Excel shows at a glance whether your real numbers stay close to plan. The actual values run as a
Dynamic Chart with Option Buttons in Excel: Age Group Count
A dynamic chart with option buttons in Excel lets you pick a department with one click and see its employees counted by age group, drawn as rows of people icons.
Dynamic Chart with Slicer in Excel: Employees by Age Group
A dynamic chart with slicer in Excel lets anyone click a department and instantly see how many employees fall into each age group. In this tutorial you build it from
Multiple KPIs Visualization in Excel with Dynamic RAG Colors
A multiple KPIs visualization in Excel lets you show ten KPIs in one eye-catching panel, with each result in a circle that turns red, amber or green on its own.