Bar Chart Column Width?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I am trying to create a Std Bar Chart with 52 Bars (1 bar
for each week) ... I am on 11x17 paper ... Issue is ...
The bars are very narrow ... I have other charts with 30
Bars on 8.5x11 paper & bar width is fine ... I do not
profess to be a Chart Guy ... What am I missing???

Thanks ... Kha
 
If u want to increase the width of the bars then follow this.


right click on any bar > format data series > options > gap width

Increase the gap width that suits you.

Regards
Asim
 
More info ... problem is not "Gap" ... I believe I have
narrowed problem down to format of X-axis Scale. I would
like X-axis to Scale Values, but it is Scaling Time ... I
assume because I am using Sunday Week Ending dates in the
Source data ... X-axis Scale set for Days, Months, Years
(not Weeks) consequently, I am getting 7 ticks along the X-
axis Scale where I only want 1. This is why I believe
column bars not getting regardless of what I do with "Gap"
of "Overlap" ... I want weekending dates on the X-axis & 1
bar at each position (not 7) ... Thanks ... Kha
 
Thanks Debra ... this was the problem ... I finally
drilled into it in the knowledge base yesterday ...
Wonderful Wizards on this board ... Thanks again ...Kha
 
Back
Top