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
Flag Chart
Charts and Visualization

Info-graphics: Flag Chart in Excel

If you have a small data set and you want to create an attractive chart then Flag chart is very nice Idea. It is very eye catching and innovative Idea. To create the flag chart we will use 2D clustered column chart, Error Bars and Shapes. Below is the data set- [caption id="attachment_8295" align="aligncenter" width="179"] Data Set for Flag Chart[/caption] Below is the Snapshot of Flag Chart in Excel. [caption
Focus Chart in Excel
Charts and Visualization

Innovation: Focus Chart in Excel

Focus chart has been created by my team to highlight the top performer on chart in very innovative way. Top performer will be focused with a hanging light. It is a dynamic chart as soon as the number will be changed in the table hanging light will be moved accordingly.   [caption id="attachment_7096" align="aligncenter" width="854"] Focus Chart in Excel[/caption] Below are data points of above given chart- [caption id="attachment_7095" align="aligncenter"