Add a DATA LABEL to ONE POINT on a chart in Excel
How to add a data label to just one data point on a chart in Excel.
Chart
How to add custom ERROR BARS in Excel charts
How to calculate and plot custom error or confidence interval data on an Excel chart.
Remove BLANK CELLS in chart data table in Excel
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.
Create a MULTI-LEVEL CATEGORY chart in Excel
How to create a chart with multi-level categories and sub-categories.
Excel Sparklines — create, resize, customize, and clear
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.
Add a REFERENCE LINE to a HORIZONTAL BAR chart in Excel
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 to a VERTICAL BAR chart in Excel
Add a reference line, such as an average or benchmark, to a VERTICAL bar chart in Excel.