•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Column bars too thin and big gap between weeks on chart - how do I make the bars thicker and/or reduce the gap between the weeks. Sales rep data per week
Our take
Are you frustrated by thin column bars and excessive gaps in your sales data charts? You’re not alone—many users struggle with visualizing their weekly sales rep leads effectively. The good news is that with a few adjustments, you can enhance your chart’s clarity and impact. In this guide, we’ll explore simple techniques to thicken your column bars and minimize the gaps between weeks, ensuring your data tells a compelling story. Let’s dive in and transform your charts into powerful visual tools!
I need to create some charts to show the sales reps leads per week - problem is the gap between my weeks is too large, and the columns themselves are too thin. Any tips on how to either reduce the gap between weeks or reduce the thickness of the columns would be much appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Trying to reorganize how data is displayed for easier formula usehttps://preview.redd.it/a6if6u7v3mpg1.png?width=2422&format=png&auto=webp&s=4e8c4809e8c6139aa0379e4fcaf4910679ba9b28 So I have been trying to figure out a way to have the sales data that I pull (A1:C11) re organize in to a chart that looks like E12:K17 but haven't had any luck. I want to use the graph from E12:K17 to do certain formulas and I would really prefer not to have to manually add all Sundays from the first chart to the corresponding column in the second chart. Any help would be much appreciated, thank you! submitted by /u/Ok_Sea_9775 [link] [comments]
- 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]
Tagged with
#rows.com#Excel alternatives for data analysis#big data management in spreadsheets#Excel compatibility#large dataset processing#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#column bars#gap between weeks#thicker columns#reduce gap#sales reps#leads per week#thickness of columns#charts#sales data#Excel#data visualization