1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there a way to create larger gaps between groups of bars in a pivot chart?

I’m working with a pivot table that contains the fields Year, Month, Attribute, and Value.

I created a stacked column chart where the bars are grouped by month, and within each month there are bars for the different years. The attributes are stacked within each bar.

What I’d like to achieve is tighter spacing between the bars within a month, but larger gaps between the months to make the groups easier to distinguish.

Is there a way to do this directly in Excel or Power BI, or is there some kind of workaround?

submitted by /u/LilTito69
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#pivot table
#stacked column chart
#Excel
#Power BI
#bars
#grouped by month
#tighter spacing
#larger gaps
#attributes
#years
#months
#Value
#Year