💻 Software
Excel 2010: Can I hide columns without excluding the data from a graph?
Fresh5 days ago
Mar 15, 2026100316 viewsConfidence Score0%
0%
Problem
In Excel 2010, is it possible to hide columns but still have the values show up in a graph? I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the columns, say, for everything before 2010, then the graph only shows the 2010 data. Is it possible to hide …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel 2010: Can I hide columns without excluding the data from a graph?
Low Risk
Solution Open the workbook and click a chart whose hidden data and empty cells you want to display. Click Design > Edit Data Source > Hidden and Empty Cells. Select 'Show data in hidden rows and columns'. From 'Show empty cells as', select an approp…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix