Possible Duplicate:
Excel 2010: Can I hide columns without excluding the data from a graph?
I have a graph based on data contained in cell columns that can be grouped. Whenever I collapse the group, in essence hiding the column, the values disappear from the graph.
How can I avoid this?
