Dynamic Variance Arrow Chart with Slicer
Charts and Visualization

Dynamic Variance Arrows Chart with Slicers

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 Chart with Variance Arrows using Slicer. This is quite useful chart to display the Sales variance in compare of previous year. We have used green and red arrow to display the percentage change. You can select multiple market in slicers using Ctrl + Click. Below
Dynamic Variance Arrows Chart with Check Boxes
Charts and Visualization

Dynamic Variance Arrows Chart with Check Boxes

In this article, we have created a Dynamic Chart with Variance Arrows using multiple check boxes. This is quite useful chart to display the Sale variance in compare of previous year. We have used green and red arrow to display the percentage change. This is a dynamic chart. if you will check any market name check box, data will be changed automatically on the chart. Below is the data for
Dynamic Chart with Scroller
Charts and Visualization

Dynamic Chart with Form Control Scrollbar

In this article, we have created a Dynamic Chart with Form Control Scrollbar. If we have multiple dates in your data, then we can use scrollbar on the chart to display rolling 10 days or 15 days data points at a time. We have used below given data to create this dynamic chart – [caption id="attachment_16355" align="aligncenter" width="439"] Data point to create dynamic Chart[/caption] Below is the dynamic chart with
Apply-Chart-Format
Excel Tips and Tricks

Apply Same Format on other Charts

In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting on this, now we want to apply same formatting on day-wise sales chart. [caption id="attachment_15802" align="aligncenter" width="835"] Month-Wise Sales Chart[/caption] Below are the steps: Just copy the month-wise sales chart Select the day-wise sales Go to Home tab >> Paste
display hidden data on the chart
Excel Tips and Tricks

Show Hidden/Collapsed Cells data on the Chart

In this article, you will learn how to display hidden data on the chart. if we create a chart for month wise sales and hide or collapse few months then those months data will not be visible on the chart. [caption id="attachment_15718" align="aligncenter" width="874"] March to July data is not visible[/caption] If you want to display the hidden data on the then below are the steps- Right click on the
Horizontal Timeline Chart
Charts and Visualization

Horizontal Timeline Chart using Scatter chart in Excel

In our previous article we created a Vertical Timeline Chart using Scatter chart. Here, we have created a Horizontal Timeline Chart using scatter chart in Excel. This is a dynamic chart. if you will add a new milestone in table, it will be reflected on the chart automatically. Below is the image of Horizontal Timeline Chart in Excel- [caption id="attachment_14872" align="aligncenter" width="1215"] Horizontal Timeline Chart[/caption] Click here to download the
Spotlight Visualization
Charts and Visualization

Spotlight Visualization in Excel (Part-2)

This is the second part of Spotlight visualization. Here we have used spotlight to highlight top performer in the chart. We have created a Column Chart for Team Manager wise sales and highlighted the team manager with the highest sales. Below is the data which we have used in this chart- [caption id="attachment_14259" align="aligncenter" width="609"] Data[/caption] We have created this chart in 2 variants. Below is the snapshot to variant-1.
Stunning Thermometer Chart
Charts and Visualization

Info-graphics: Stunning Thermometer Chart in Excel

I am back with one more innovative chart which is a Stunning Thermometer Chart. This chart can be used for display KPI metrics. You can display your data by category also like Zone Wise or Month wise etc. We have created it for Zone wise service level. [caption id="attachment_11261" align="aligncenter" width="277"] Zone Wise Data[/caption]   Below is the snapshot of Stunning Thermometer Chart [caption id="attachment_11263" align="aligncenter" width="599"] Stunning Thermometer Chart[/caption]
Small Charts for Weekly Performance
Charts and Visualization

Small Charts for Weekly Performance

While creating a dashboard, many times it happens when you don’t have the sufficient space to place your multiple chart. You can create the small charts to display your weekly performances. These charts are very small but readable. Below is the data set for which we have created these small charts. [caption id="attachment_11139" align="aligncenter" width="174"] Small Charts for Weekly Performance[/caption]   Below are the Weekly Charts available. We created these
3D Glass Chart
Charts and Visualization

3D Glass Chart in Excel

I am back with a very innovative and Informative chart that is 3D Glass Chart in Excel. This chart can be used to display a KPI metrics like Service Level, Quality Score, Productivity etc. Here we have created this chart for Zone Wise Service Level. Below are the data points for which we will create this chart [caption id="attachment_8337" align="aligncenter" width="232"] Data Sets[/caption] Below are the steps to create this