Infographics with Line Chart in Excel: Use Icons as Markers
Infographics with a line chart in Excel means swapping the plain round markers for meaningful icons: a shopping cart for sales, a money bag for revenue and a location pin
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.
RYG Dial Gauge Meter in Excel: Build a KPI Gauge Without VBA
An RYG dial gauge meter in Excel shows a KPI the way a car dashboard shows speed: a needle points into a red, yellow or green zone, so anyone can
Picture Effect in Excel Chart: 3D Charts with the Camera Tool
A picture effect in an Excel chart turns a flat column chart into something that looks like a 3D display board standing on a floor, with a reflection underneath. Excel
Conditional Formatting in Multiple Batteries Chart in Excel
Conditional formatting in a multiple batteries chart lets one Excel chart show several KPI values as 3D battery cells that turn green when the target is met and red when
Traffic Lights in Excel: KPI Status Lights Without VBA
Traffic lights in Excel are one of the quickest ways to show KPI performance: red when a metric is below target, yellow when it is in the warning band and
Balloon Chart in Excel: 3D Bubble Chart With Strings
A balloon chart in Excel is a playful alternative to a column chart: every value floats as a glossy balloon on a string, and the higher the value, the higher
Ring Chart in Excel: 3D Doughnut Chart with a Live Total
A ring chart in Excel is a doughnut chart dressed up to look like a shiny 3D ring, with the total shown right in the middle. It is a great
Comparison Infographic in Excel: Team vs Team Balance Chart
A comparison infographic in Excel turns a dry Team A vs Team B table into a see-saw: two 3D balls sit on a golden beam, and the beam tilts towards
Filling Circle Chart in Excel: KPI Infographic Without VBA
A filling circle chart in Excel shows a KPI as a circle that fills up like a glass of water: 25% fills a quarter, 100% fills the whole circle. It
Target Vs Actual Sales Dynamic Chart
When it comes to tracking sales performance, a dynamic and interactive chart is often the best way to go. In this article, we’ll show you how to create a Target vs