The Gap Width option in Excel for Mac 2011 controls the spacing of bars in a column graph. Decreasing this percentage shrinks the empty space between columns by widening the columns themselves.

Have you ever struggled to make sense of a dataset with too many categories or time-based data? It’s a common challenge—how do you present individual contributions while still showing the bigger ...

Businesses and professionals commonly use Microsoft Excel to calculate earnings and financial results, but users can also create chart graphics that complement the data. Organizations report quarterly ...

So, you need some eye-popping visuals to show off your top sales numbers for that meeting in 40 minutes but data, not design, is your forte. No problem. With Excel 2013—even if you’ve never used ...

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data. Sometimes a chart’s underlying data doesn’t fit in the chart window. When ...

Viewing the distribution of related values from one entity to another is a frequent request, and that’s where Microsoft Excel floating bar charts can help. Instead of starting from the X axis, the low ...

Editorial Note: Forbes Advisor may earn a commission on sales made from partner links on this page, but that doesn't affect our editors' opinions or evaluations. A Microsoft Excel spreadsheet is one ...