•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?
Our take
Creating visual clarity in your pivot chart is essential for effective data presentation. If you’re looking to achieve tighter spacing between bars within a month while increasing gaps between different months, there are strategies you can explore in both Excel and Power BI. These adjustments can enhance the readability of your stacked column chart, making it easier to distinguish between groups. Let’s delve into the methods available to fine-tune your chart layout for a more impactful data visualization experience.
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]
Read on the original site
Open the publisher's page for the full experience
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