Hi,
Once you create a chart (Bar) is i possible to keep the same size column, widths as you use the slicer to scroll through the various items ? For example if my chart has 3 items, the sizing of the columns is good, if the chart only shows one item the column width has increased - trying to maintain uniformity.
Hi Mike,
No, this is a "feature" of the Pivot Charts.
Mynda
I struggle with this as well. My dashboard layout is fluctuating a lot based on the items I choose to filter by, or upon refresh. I find it puzzling that there would be no way to lock the dimensions or position of the charts, table columns or filter positions. Are there any tricks that could help with this?
Pivot Charts are designed to adapt to the amount of data in a PivotTable while maintaining the overall size of the chart area. If you want to lock down the chart layout in regards to the column width then you need to use a regular chart where you can include a fixed number of series in the chart whether they have data or not, based on Slicer selection. See attached.
Mynda