In this tutorial, we will show a simple trick to show charts with hidden data in Excel. Microsoft Excel is quite useful for analyzing trends and patterns in large data, It is easy to lay, reformat, ...

A percentile graph visualizes the percentiles of a given data set. The graph will show a box suspended on the graph that represents the area between the 25th and 75th percentile. The graph will also ...

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data. Sometimes a chart’s underlying data doesn’t fit in the chart window. When ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same color by default. Another way to display the chart is to change the color of the ...

Excel puts lots of great tools on your desktop, but what each one of them does isn’t always obvious, especially since so many Excel features are hidden. Would you like to create multiple lines of text ...