How to Add a Trendline in Excel Charts?
A trendline, also known as the ‘line of best fit‘ is an important visual tool in data analytics. It is a straight (or curved) line that helps us understand data …
Charts
In this section, you will find easy-to-follow tutorials about creating charts in Excel. It also covers simple tips and how-tos about Excel charting.
How to Create a Waterfall Chart in Excel?
Waterfall Charts are a popular mode of visualization, especially when it comes to analyzing and understanding change. They are known by different names like McKinsey Charts, Cascade Charts, and even …
How to Create Win/Loss Sparklines Chart in Excel?
Charts are always a great tool to visualize data. However, sometimes instead of a full-blown chart, you might prefer smaller charts that are more dedicated to a smaller subset of …
How to Delete Chart in Excel? (Manual & VBA)
Charts are an excellent visualization tool, which is why we often end up having one too many in our worksheets. Sometimes we might even end up having multiple copies of …
How to Create Org Chart in Excel?
An Org chart is a great way to visualize hierarchy or the flow of information/command in an organization. You will find Org charts available through the SmartArt feature in most …
How to Make Box Plot (Box and Whisker Chart) in Excel?
Box plots (also called box and whisker charts) provide a great way to visually summarize a dataset, and gain insights into the distribution of the data. In this tutorial, we …
How to Add Gridlines in a Chart in Excel?
To make the data in a chart/graph easier to read, it helps to add horizontal and/or vertical gridlines. Gridlines are lines that go horizontally and vertically across your chart plot …
How to Insert Chart Title in Excel?
A chart or graph provides a great way to visually present data. It lets a viewer get the gist of the data at a glance and is, therefore, a frequently …
How to Create Bar of Pie Chart in Excel?
Pie charts in Excel provide a great way to visualize categorical data as part of a whole. By one look at a pie chart, one can tell how much a …
How to Switch Axis in Excel (Switch X and Y Axis)
Sometimes, when you create a chart in Excel, you may want to switch the axis in the chart (i.e., interchange the X and the Y-axis) It’s really easy, and in …
How to Move a Chart to a New Sheet in Excel
Charts are a great way to get a visual representation of your data. Excel provides a host of options to create and customize charts. It usually displays your created chart …