Fish Chart in Excel
Charts and Visualization

Fish Chart in Excel

Fish Chart is my lasted innovation. I have used it to display sales data points. The new thing is that fishes are getting changed randomly whenever worksheet is recalculated.  I have used 3 fishes here. Data label is in front of fish’s mouth looking as a water bubble. I have used Line Chart to create this. Below is the data set for fish chart. [caption id="attachment_8475" align="aligncenter" width="166"] Data Points[/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"
Slide Meter Chart (Ver-3)
Charts and Visualization

Slide Meter Chart (Version-3)

This is the version-3 of Slide Meter Chart. In the Slide Meter Chart (Version-1), we displayed the KPI metric performance with solid bar. In the Slide Meter Chart (Version-2), we displayed the KPI metric performance with semi filled bar. Now in this version of Slide Meter we have put the conditional formatting. If the value of Service Level will be less than target then it will be in Red otherwise
Slide Meter Chart (Ver-2)
Charts and Visualization

Slide Meter Chart (Version-2)

This is the version-2 of Slide Meter Chart. In the Slide Meter Chart (Version-1), we displayed the KPI metric performance with solid bar but in this version-2, we have displayed the KPI metric performance with semi filled bar.  This is a very eye catching chart and can be used in the business dashboard. [caption id="attachment_7022" align="aligncenter" width="856"] Slide Meter Chart (Ver-2)[/caption]    Click here to download this Excel workbook.  
Slide Meter Chart
Charts and Visualization

Slide Meter Chart – Version 1

Slide Meter Chart is very useful and eye catching chart to show the KPI metrics performance. This chart has been designed with the help of Column Chart, Line Chart and Auto shapes. Below is the data points which has been used to create this beautiful chart- [caption id="attachment_7009" align="aligncenter" width="232"] Data Point for Slider Meter Chart[/caption]   Below is the Slide Meter Chart (Ver-1). [caption id="attachment_7011" align="aligncenter" width="674"] Slide Meter
Highlight the data point
Charts and Visualization

Highlight the Specific data point in a Line Chart Dynamically

In this chart we have highlight the Minimum, Maximum and Selected data points in a beautiful line chart. This chart can be used in Business Dashboard or Presentation. Below is the snapshot to highlight the Minimum data point [caption id="attachment_6991" align="aligncenter" width="943"] Highlight the Minimum data point[/caption]    Below is the snapshot to highlight the Maximum data point [caption id="attachment_6994" align="aligncenter" width="950"] Highlight maximum data point[/caption] Below is the snapshot
Innovative Chart
Charts and Visualization

An Innovative chart for team level performance

This innovative and eye catching chart, we have created using Line with Marker chart. In this chart we have displayed 7 teams and their performance. Below is the team wise Performance Score table. [caption id="attachment_6954" align="aligncenter" width="251"] Team Wise Performance Score[/caption]   This Chart can be used in Business Dashboards or Presentations.     Click here to download this Excel workbook.   Watch the step by step video tutorial:
Info-graphics with Line chart
Charts and Visualization

Info-graphics with Line Chart

We can use the Info-graphics icons in a Line Chart in place of Markers. It will make your chart more attractive. Info-graphics icon should be related to the chart category/data points so that it will make sense. Below are the few examples of line chart wherein we have used info-graphics: Sale by Year: [caption id="attachment_3864" align="aligncenter" width="492"] Sales by Year chart[/caption] Revenue by Quarter: [caption id="attachment_3867" align="aligncenter" width="496"] Revenue by
Chart Templates in Excel
Charts and Visualization

Chart Templates in Excel

In this article you will learn how to save a chart as template in MS Excel. You can save our favorite chart as a template reuse it or make company’s standard chart template. So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it seconds. How to save a chart as