All articles with 'collapsible charts' Tag

Collapse, Expand Excel Charts using this hidden trick

Published on Jan 12, 2010 in Charts and Graphs
Collapse, Expand Excel Charts using this hidden trick

Do you know that you collapse or expand excel charts? Don’t believe me? Me neither. When I first realized that we can collapse / expand charts without writing any macros or lengthy formulas, I couldn’t wait to share it with all of you. This is such a simple yet powerful trick. See it for yourself.

The trick lies in using group / un-group data feature and carefully aligning charts with the cell grid. The whole process takes just about 2 minutes and produces wow factor worth a week. Go check it, now. Also, a downloadable template is included in the post.

Continue »