Slide Meter Chart in Excel (Version 1): Solid KPI Bars
A slide meter chart in Excel shows a KPI as a bubble that slides up and down a rounded track, so you can read every day's score at a glance.
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.
Conditional Formatting in a Line Chart in Excel: Green vs Red
Conditional formatting in a line chart lets you colour each data point by a rule, just like conditional formatting colours cells. In this tutorial you build a month-wise Service Level
Highlight a Data Point in an Excel Line Chart Dynamically
Want to highlight a data point in a line chart dynamically, so the highest month, the lowest month or the month you click on lights up with a big gold
Animated Hourglass Chart in Excel: Step-by-Step with VBA
An animated hourglass chart in Excel turns a plain KPI percentage into a small piece of motion: type a new value and the sand drains from the top bulb into
Innovative Chart for Team Level Performance in Excel
This team level performance chart in Excel turns a plain list of scores into an eye-catching graphic: seven coloured lines burst out of one glowing point and end at each
3D KPI Indicator in Excel: Red, Yellow, Green Traffic Light
A 3D KPI indicator in Excel works like a traffic light for your metrics: three glossy balls in a grey frame, and only one lights up, red, yellow or green,
Filling Stacked Column Chart in Excel: 3D Ball KPI Infographic
A filling stacked column chart in Excel turns a plain percentage into a column of 3D balls that fill up like a gauge. In this tutorial you will build it
Dynamic Project Planner Gantt Chart in Excel (Daily/Weekly View)
A dynamic project planner in Excel shows every activity of a project as a coloured Gantt bar and switches between a daily and a weekly timeline with one drop-down. In
KPI Infographic Column Chart in Excel: Filling Shapes (Part 2)
A KPI infographic column chart in Excel shows a percentage metric, such as service level, as a shape that fills up like a glass of water. A 64% zone is
Infographic Column Chart in Excel: 4 Picture Styles (Part 1)
An infographic column chart in Excel swaps the plain blue bars for pictures, such as arrows, rockets, money bags or pencils, so a simple Sales by Manager report grabs attention