Connect Line Data Points
How-to Connect Gaps in a Line Chart in Excel
How to connect Excel line charts when you have missing data, gaps in data or blanks in data.
EXPLORE THE LIBRARY
Tag
Column Chart
How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart
Video tutorial on how to create a horizontal line chart combined with an Excel 2D Clustered Column Chart.
Area Chart
How-to Make an Excel Area Chart Cliff (Fiscal Cliff Edition)
how to make an Excel Area Chart Cliff instead of a slope for excel 2010 and excel 2007
Box
Grouping Excel Column Charts with a Box
Excel charting technique to add a floating box group created with an XY Scatter Line Chart
Chart
The Tricks to Writing a Conditional Formatting Rule Formula
The best tips and tricks about wrting excel conditional formattting rules and formulas for spreadsheet dashboards.
Chart
How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and Rows
video tutorial How to stoping Excel from losing data or resizing charts and graphs when you show or hide columns and rows.
Axis Formating
How-to Make an Excel Vertical Likert Line Chart with Categories
How to make a vertical excel line graph with vertical categories using standard excel charting techniques.
Bar Chart
How-to Make Conditional Label Values in an Excel Stacked Column Chart
How to tutorial and video tutorial on making a conditional data labels in a stacked column chart or stacked bar chart in Excel.
3D Chart
How-to Fix an Excel 3D Chart so that it Matches the Gridlines
My 3-D Excel Chart doesn't match the Major Gridlines Error
Chart
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
Excel Charts and Dynamic Dashboard for 2012 Summber Olympic Medal Count