Add a vertical line to Gantt Chart or Stacked Bar Chart in Excel –...
In last tutorial on gantt chart in Excel for project managers we learnt the simplest and fastest way to chart project activities/tasks. Today we are learning how to add a vertical line on the...
Making a Slope Chart or Bump Chart in Excel – How To
Excel has many different styles of charts and graphs inbuilt and one can make them with a single click. A great convenience to have. But for charts and graphs convenience is required, merited and...
Dynamically Highlight data points in Excel charts using Form Controls
Charts and graphs and other visual means make information easier to understand and analyze. Excel gives plenty of options in this department as different types of graphs are possible.
But in some cases wrong chart types in...
Create Project Timeline Charts in Excel – [How To] + Free Template
Today we are learning how to create project timelines or project timeline charts in Excel. One can say that timeline charts are simpler versions of gantt chart as they usually don't involve activity's stage...
Gantt Chart in Excel – How To + Free Template + Online Gantt Chart...
Gantt chart is the simplest-most effective visual for planners and project managers. The most favourite tool to make gantt charts is Excel for two reasons:
we curate data in Excel and;
Excel stacked bar...
Make Waffle Charts in Excel using Conditional Formatting – How To
To get the inspiration for better charts and Excel dashboards one must be observant of such pieces of information that are often found in newspapers and the internet. For that matter, Pinterest and The...
Enable or Disable Excel Data Labels at the click of a button – How...
Data labels in Excel charts can help users to get the information right at that spot without referring to any other source of information. In some situations however, same data labels can get in...
Making Horizontal Dot Plot or Dumbbell Charts in Excel – How To
Dumbbell charts also called connected dot plot or DNA chart or lollipop charts are not available as builtin charts in Excel by default. But they prove awesome visual aid in certain situations. A great...
Creating Scrollable Charts in Excel [How To]
Last time we discussed on how to have a subset of data within worksheet that scrolls independently and I called it scrollable data ranges. It was fun as we involved one of the Excel...
Excel Chart with highest value in different colour – Multi Color Bar Charts [How...
Reports and charts goes together and the biggest reason to have charts in reports is to add visual treat that makes it super easy for everyone to decide instantly. To toss it even further...