bar char - bar width

J

Jeff Reese

I've created a simple, standard bar chart in Excel. Oddly, Excel by default
has made the widths of the bars themselves extremely narrow. I have never
seen this behavior before. Any ideas what may be causing this and
suggestions on how I can fix it?

Thanks.
 
J

Jon Peltier

Is this weekly data, for instance? Excel might interpret dates and provide
seven slots for one weekly value, leaving you with six empty slots per
filled point. Change from a time scale axis to a regular category axis: go
to the Chart menu, Chart Options, Axes tab, and under Category (X) Axis,
change Automatic to Category.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

bar chart - bar width 0
Template location changes from user to user 0
stacked bar chart - problem adjusting bar width - Excel 2007 0
Bar width on existing chart changes when changing source data 5
Charting a line and a bar on the same chart 1
Table Preferred width is changed when pasting 1
bar inside larger bar 2
Stacked columns width too thin - how can I alter? 1

Top