Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I've attached a word doc with a screen shot of my QV page. I have pivot tables below all my graphs (see attachment). I would like to pivot table to always be the same size as the graph. Right now I have dimension limits in there to limit the box to 18 months ( from today's date). That works somewhat but depending on the time of the month, I get 17 or18 months hence the size of the box changes. Any ideas? I would like to always have it limited to 18 periods. Thanks, Jim
Uncheck 'Size To data' checkbox on Layout tab in pivot properties.
Uncheck 'Size To data' checkbox on Layout tab in pivot properties.
You da Man!! Thank you!