What I was hoping for, if you look at the first picture, is that when I insert classification summary into the legend, that all cells will then be shown. That means that I now have to manually add every single cell that was previously within that range. The unmerging of the cells means that the category "Classification summary" is no longer applied to the previous range, and is now limited to the cell below. The next problem is that due to the unmerging of the cells, the resulting pivot table is much more cumbersome to work on, than first intended. As this negatively impacts the layout, is there a way to "merge" the cells, without really merging them? Maybe something like an overlap feature? I then unmerged all cells and autofilled the blanks with a 0. The first problem that I stumbled upon is that when creating a pivot table, you have to unmerge cells. The best way to do that, was instinctively a pivot table. I'm trying to set up a worksheet in order to organize and visualize data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |