•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
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