![Pivotpoint Pivotpoint](/uploads/1/2/5/7/125745587/849157428.png)
I'm trying to modify the 'Personal Expenses Calculator' Template for my Father. It seems to have some nice features that I would like to incorporate, however it is dealing with Pivot Tables which I have no real experience with. Hoping someone can help me out. I have changed the categories in the 'Category Setup' sheet to the categories I want and have removed the default entries.
![Xls Xls](/uploads/1/2/5/7/125745587/824730309.jpg)
- Points
- 93,501
- Posts
- 18,188
I've created a Pivot Chart in which I want to display travel by various folks to mulitple sites. The Site field is a Page field. If I set the Pivot Chart to a Custom -- Floating Bar style it displays fine, but if I change the Page field selection the chart reverts back to a stacked bar style.I've tried setting the default chart type to Floating Bar (this doesn't take), and naming a custom style that is Floating Bar (and setting the pivot chart to this custom style -- but again the style does not hold on a change to the Page field).I ran into this a few years ago and wrote some event macros to reformat the chart when the sheet is activated and when it calculates, but it seems there should be a simpler (built-in) way. Am I missing something obvious? Is there a way to make the Floating Bar style stick in a pivot chart without resorting to VBA updating?- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.