I created two pivot tables and next to them two pivot charts.
Of course the pivot tables show up with different lenghts when the underlying data changes. Therefore I left a lot of blank rows between the two pivottables.
Because I cannot use macro's I am trying to find way to set the position of the second pivot table relative to the end of the first pivot table.
See my comments on your previous post. It seems like the best plan of attack is to use a pivot table update event and hide the rows or make them them visible as needed. Are the two pivot tables based off the same data set (in other words, do they refresh simultaneously)?
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Hello dflak, thank you for your answer.
As said in my previous post, I cannot use VBA, so use of the pivot-table-update event is not possible I suppose.
My excel files are build from some kind of excel template, and filled by another program that doesn't allow me to create xlsm files.
So I am still looking for a way to have only one or two rows between the pivot-tables after the data is refreshed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks