All articles with 'collapsible charts' Tag
{ 12 Comments }
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](https://chandoo.org/img/c/expand-collapse-charts-thumb.gif)
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 »