The Last Lesson Summary Short Another reason for skinny columns is the category axis being dates e g You have weekly data so the columns are space 7 days apart Right click chart and pick chart options
From the Insert Column or Bar Chart group select 2D Clustered Column chart You can see a column chart bar that is thin Let s solve this issue Solution Right click on the The chart has a full quarter s worth of data by week If I change the date range to just a couple of week the bars are so thick they look like boxes not bars
The Last Lesson Summary Short
The Last Lesson Summary Short
[img-1]
[img_title-2]
[img-2]
[img_title-3]
[img-3]
It may be inserting dates that you have no data for there fore shrinking the dates that you DO have data for However if they re just too thin you can right click on one of the The past week my bar charts have displayed as thin lines single bar and clustered adjusting series overlap and gap width has not effect this problem occurs when I
When I select the date data in the Category X Axis box the bars shrink in width such that you cannot see the fill colors The settings in the series option menu does not affect When I plot the data on a line graph with a date time axis this happens The Graph automatically inserts the missing years the shaded blue area scrunching up the remaining
More picture related to The Last Lesson Summary Short
[img_title-4]
[img-4]
[img_title-5]
[img-5]
[img_title-6]
[img-6]
On the Insert tab of the ribbon insert a Stacked Bar Chart It looks wrong but don t worry On the Design tab of the ribbon click Select Data You don t want Serial No as a series I ve put them on different axis and one is a bar chart one is a line chart However since I have done this as a weekly figure with the date being the first day of the week the
[desc-10] [desc-11]
[img_title-7]
[img-7]
[img_title-8]
[img-8]
https://www.excelforum.com › excel-charting-and-pivots
Another reason for skinny columns is the category axis being dates e g You have weekly data so the columns are space 7 days apart Right click chart and pick chart options
https://www.exceldemy.com › excel-chart-bar-width-too-thin
From the Insert Column or Bar Chart group select 2D Clustered Column chart You can see a column chart bar that is thin Let s solve this issue Solution Right click on the
[img_title-9]
[img_title-7]
[img_title-10]
[img_title-11]
[img_title-12]
[img_title-13]
[img_title-13]
[img_title-14]
[img_title-15]
[img_title-16]
The Last Lesson Summary Short - When I plot the data on a line graph with a date time axis this happens The Graph automatically inserts the missing years the shaded blue area scrunching up the remaining
