Help--I've been learning Powerpivot on the fly, and have created a lovely dashboard. The problem is that when I refresh the data, and/or when I change views via slicers, the chart type (which is a combo chart) reverts back to a plain bar chart. I've tried googling a solution, but haven't found anything yet that works. I've ticked off all the options boxes suggested in various google solutions. One google solution I didn't try was to build the chart from formula references to the table--I'm not sure if I can do that in Powerpivot? I did save a copy of a chart in the format I wanted as a template, but I couldn't figure out how to invoke it. There must be a way to do this so that my end users aren't boondoggled by constantly broken charts. Anyone have any tips?!
Bookmarks