Hi,
I'd like to put together an output page that stays within Excel for all of my graphs / charts / etc. that comes from underlying data on a different tab. Let's call it "output tab." What I'd like to be able to do is simply print the output tab whenever I want to look at the charts. Order is important here, so I need to be able to add and delete pages throughout.
My question is re: the easiest way to manage this. Since I'll be adding pages here and there, is it possible to "add page" in a manner similar to Powerpoint? Where if I'm on page 5 of this output (pg. break preview) and I want to add an additional page right there, i can just insert a page somehow? I know that I can add columns each time but seeing if there is a better way.
Also it would be preferable to have these pages go in this kind of order:
1 2 3 4
5 6 7 8
instead of this order:
1 2 3 4 5 6 7 8
since it's so much easier to manage, especially as the page count increases. In the first scenario I wouldn't even be able to add a page the typically way of inserting columns without screwing up all the pages below it. And actually it would be great if in the top example above pg. 4 goes to the spot where pg. 5 is when I add the page.
Hopefully this makes sense, interested in any suggestions to make my life easier as I try and build this.
Thanks!
I'd like to put together an output page that stays within Excel for all of my graphs / charts / etc. that comes from underlying data on a different tab. Let's call it "output tab." What I'd like to be able to do is simply print the output tab whenever I want to look at the charts. Order is important here, so I need to be able to add and delete pages throughout.
My question is re: the easiest way to manage this. Since I'll be adding pages here and there, is it possible to "add page" in a manner similar to Powerpoint? Where if I'm on page 5 of this output (pg. break preview) and I want to add an additional page right there, i can just insert a page somehow? I know that I can add columns each time but seeing if there is a better way.
Also it would be preferable to have these pages go in this kind of order:
1 2 3 4
5 6 7 8
instead of this order:
1 2 3 4 5 6 7 8
since it's so much easier to manage, especially as the page count increases. In the first scenario I wouldn't even be able to add a page the typically way of inserting columns without screwing up all the pages below it. And actually it would be great if in the top example above pg. 4 goes to the spot where pg. 5 is when I add the page.
Hopefully this makes sense, interested in any suggestions to make my life easier as I try and build this.
Thanks!