Charts and Visualization Archives - Page 8 of 16

Sales Dashboard Power View in Excel 2013

December 30, 2019March 3, 2025 PKComments Off

Sales Dashboard Power View in Excel 2013 In this article, we have created a beautiful Sales Dashboard Power View in Excel 2013. [caption id="attachment_22871" align="aligncenter" width="964"] Power View in Excel[/caption]

Charts and Visualization

5 Layered Advanced Doughnut Chart

December 2, 2019March 3, 2025 PKComments Off

5 Layered Advanced Doughnut Chart In this article, we have created the 5 Layered Doughnut Chart to display the KPI value up to 500%. We have created two different version

Charts and Visualization

RAG waffle Chart visualization with Slicer

November 18, 2019March 5, 2025 PKComments Off

In this article, we have create a RAG waffle Chart visualization with slicer to display the Red, Amber and Green percentage. We have used Conditional Formatting and linked picture feature

Charts and Visualization

Dynamic Performance Chart in Excel

November 7, 2019March 3, 2025 PKComments Off

In this article, we have created dynamic Performance Charts. We have used excel shapes and Doughnut Chart here. To make these charts dynamic we have used Form control option buttons. Dynamic

Charts and Visualization

Data Driven 3D Table in Excel

October 17, 2019March 8, 2025 PKComments Off

In this article, we have designed a data driven 3D table in Excel. We have used Linked picture and excel shapes to create this table. You can use this in

Charts and Visualization

Timer Chart Visualization in Excel

October 14, 2019March 6, 2025 PKComments Off

In this article, we have created a beautiful data driven Timer Chart visualization. You can use this chart to display KPI metrics like Service Level, Quality Score, Sales conversion etc.

Charts and Visualization

Dynamic Conditional Formatting in Excel

October 10, 2019March 6, 2025 PKComments Off

In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights

Charts and Visualization

Animated Speedometer Chart in Excel

September 3, 2019March 5, 2025 PKComments Off

In this article, we have created an Animated Speedometer Chart in Excel using Charts and VBA. This beautiful chart can be used in your business dashboard. An animation will run

Dynamic Variance Arrow Chart with Slicer

Charts and Visualization

Dynamic Variance Arrows Chart with Slicers

August 29, 2019March 10, 2025 PKComments Off

In the previous article we create a Dynamic Chart with Variance Arrows using multiple check boxes. In this article, we have created the similar Dynamic Variance Arrows Chart with Slicers.

Charts and Visualization

Dynamic Variance Arrows Chart with Check Boxes

August 27, 2019March 10, 2025 PKComments Off

In this article, we have created a Dynamic Variance Arrows Chart with Check Boxes. This is quite useful chart to display the Sale variance in compare of previous year. We