Excel Sorting Data Tips – With the help of Excel Sorting Data Tips we looking for solutions for very interesting problems today. How to sort dynamically a list containing two columns (‘Product’ and ‘Sales’ columns) at will only using excel functions? On the second worksheet we will show you a solution based on the on the fly sorting technique. It is well capable of give us help in creating an excel dashboard or other visualization tasks especially when available space is scarce.

From Excel 2013, you can use a new chart type named sparklines. Sparkline is mini charts located in single cells. Each cell shows a series of data in your range. It helps bring meaning and context to numbers being reported. Select the data and insert chart!

This type of graph – compared with classic chart templates – is meant to be embedded into what they are reporting.
To create new styles, use the Design tab on the ribbon and customize your sparklines to match whatever visual style you need. If you find a space-saving method, use sparklines instead of charts.

Gantt chart templates are useful tools for managing and scheduling projects in Excel. If you want to build a graph, you have two options. With a few steps, you can turn a simple bar chart into a Gantt Chart. In this case, Chart Formatting is important. As first, right-click on any of the bars on the chart to modify existing charts. Remove extra spaces between the graphs using the Gap Width. Another solution is based on conditional formatting. You can use different colors to highlight the task status.