How to add a data label to just one data point on a chart in Excel.
How to calculate and plot custom error or confidence interval data on an Excel chart.
How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by ‘N/A’ values using an IF statement.
How to create a chart with multi-level categories and sub-categories.
How to use Excel’s Sparklines — mini column, line and win-loss charts. See how to create and customize sparklines to show data trends, and how to clear or delete sparklines from a worksheet.
To add a reference line such as an average or benchmark to a horizontal bar chart. step by step guide with videos and screenshots.
Add a reference line, such as an average or benchmark, to a VERTICAL bar chart in Excel.