Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Re: Cannot format width of bar graph
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Re: Cannot format width of bar graph
 |
Re: Cannot format width of bar graph |
|
|
Thread Tools | Rate Thread |
22-09-2003, 05:42 PM
|
#1 |
|
Guest
Posts: n/a
|
Re: Cannot format width of bar graph
That's it! Thanks a lot!
>-----Original Message----- >Catherine - > >Right click on the chart, select Chart Options from the pop up menu, >click on the Axes tab, and change the option under Category axis from >Automatic (or Time Scale) to Category. Excel thinks you want to use the >date values for your category axis, and leaves spaces for every day, >even if you only have data intermittently. > >- Jon >------- >Jon Peltier, Microsoft Excel MVP >http://www.geocities.com/jonpeltier/Excel/index.html >_______ > >C. Land wrote: >> I create a bar graph with three bars per date (a bunch). >> However, the area that the chart attempts to place these >> three bars is so tiny that all I end up with is three >> black lines (it's so small it is showing only the outline >> of the bar, not the color). There is a HUGE gap between >> the bunches and I cannot seem to narrow this gap. If I >> could fill in this space, the bars would be visible. I >> have tried changing the "gap width" to zero, the "offset" >> to zero and the "overlap" to zero. >> >> Help! > >. > |
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
