View Single Post
  #6   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Whether one likes a particular effect or not is a subjective matter.
To disallow a feature for its entire customer base because one person
doesn't like it would be a rather draconian step for MS to take,
wouldn't it?

You can use formatting to focus the eye on the bars. Double-click the
plotted series and from the Patterns tab set the border to none and
pick a bright color for the area (red or blue works well).

If you still don't like the effect, I don't know what to write. Just
keep this in mind. The bars are as thick as they possibly can be given
the requirement that there be space for 365 possible bars. To see
that, stretch the chart out horizontally over 20 or 30 columns. The
bars will get thicker.

If you feel strongly enough about this, let MS know. Visit
http://register.microsoft.com/mswish/suggestion.asp

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , says...
If you're saying that bar charts don't work in this case (ie the bars
are too thin to be of any use) then the software should prevent people
from specifying bar charts under these conditions.

Your "advice" to changing the gap is a non-starter....it doesn't work.
Its beginning to sound like this is a lost cause...

Tushar Mehta wrote:
What do you expect XL to do? You want sufficient horizontal space for
365 entries and XL is giving it to you. The result is that each day
occupies only 1/365th of the horizontal space of the plot area.

You *might* get some additional thickness by double-clicking the
plotted series, selecting the Options tab, and setting the Gap Width to
zero.