Moving X-axis labels at the bottom of the chart below negative values in Excel

By default if you insert a bar chart or line chart, the x-axis labels are stuck at 0 position of the axis. This usual behaviour gets in the way especially if you have negative values...

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...

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...

Variance Analysis in Excel – Making better Budget Vs Actual charts

Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...

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...

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...

10+ ways to make Excel Variance Reports and Charts – How To

Whether it is daily life thing or any day at work, we are always comparing to see whats good and what is not so good. This differential analysis has a much popular name as variance...