12
2
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 the columns, but still have the data in the graph?
Not working in Excel 2016, The button is grayed out when sourcing data from a Pivot table using a tabular layout format. – CodeMonkey – 2018-09-12T12:57:57.350
2Why did someone down vote this? It is the right answer. – Sux2Lose – 2011-05-16T15:34:19.110