Download Collapsible Excel Chart TemplateĬlick here to download collapsible excel chart template. Go ahead and show it off to your boss or colleague, just wow them. Once you finish it, the collapsible chart is ready. This step is very straight forward in Excel 2007, but in Excel 2003 it takes some patience. Depending on excel version, you need to carefully adjust the chart’s size and position (top, left) and data series gap so that when you press “collapse” button from grouping area on left, the chart also collapses neatly. Finally Adjust Chart Positions so that when you Group the Chart Collapses To group rows, go to Data Ribbon > Group in Excel 2007+ orĭata Menu > Group and Outline > Group in Excel 2003. Just select all the rows with detailed data (in our case, the monthly sale values) and group them. Now select the detail rows and Group them Remove any chart axis, grid lines etc if you feel like.Īt this point our set up should look like this:ģ. Make sure you position the charts in blank columns. Since the data is in rows, select a bar chart. Select data for each year and make one chart. Make charts and Position them in the extra column Also summary row (in our case – yearly total) is added and calculated using a formula. You can also place your data in columns instead of rows. Make sure you have an empty column next to each series of data. If you want to collapse / expand an excel chart like this, Just follow the below steps. This is such a simple yet powerful trick. 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. Do you know that you collapse or expand excel charts? Don’t believe me? Me neither.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |