View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Your axis is set so the base unit is days. Each bar must then fit within
a band 1/365th the width of the chart. If you change the base unit to
months, you will have two ro sometimes three points occurring at the
same month.

You shoucl consider changing from time scale to category for the axis.
Choose Chart Options from the Chart menu, click on the Axes tab, and
select Category under Primary X Axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

MrC wrote:

I have a bar chart with dates on the xaxis being resorted (primary axis
= automatic). There are 26 entries over a one year period. The trouble
is the bars come out as vertical lines, I can't set the xaxis format so
that they have any thickness. If I set the chart to not sort the xaxis
then the bars are okay.