If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot format width of bar graph
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! |
#2
|
|||
|
|||
Cannot format width of bar graph
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! |
#3
|
|||
|
|||
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 | |
Display Modes | |
|
|