💻 Software
Making line charts so the line goes through all data points
Fresh5 days ago
Mar 15, 2026108368 viewsConfidence Score0%
0%
Problem
I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around? I've created a line and X-Y scatter charts to show the movement (quantity sold) of these products over the…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Making line charts so the line goes through all data points
Low Risk
Hopefully the following image is self-explanatory: The complete command sequence in Excel 2007 is: Select your chart Select Chart Tools → Design on the Ribbon Select "Select Data" Select "Hidden and Empty Cells" Select "Connect data points with line…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix