Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Re-size Bars in Bar Graph
All I want to do is make the bars bigger (they are pin thin) on my verticle
(2-D) Bar Graph. I tried clicking on a series and going to options and changing the 'Gap Width' and it didn't do anything, I also tried decreasing the 'Overlap' number and nothing. I also tried making the graph area bigger and that didn't work either. I have dates on the X-axis (3 series each) and the are spaced so far apart there should be plenty of room to make the bars bigger. My bars are so close together and pin thin it's hard to read. Any suggestions would be greatly appreciated. Thanks in advance, SLKoelker |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Re-size Bars in Bar Graph
Hi,
Sounds like you want category xaxis rather than true date, which is causing the skinning columns. Right click chart and pick chart options. On the Axis tab set the X axis to Category rather than Automatic or Time series. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SLKoelker" wrote in message ... All I want to do is make the bars bigger (they are pin thin) on my verticle (2-D) Bar Graph. I tried clicking on a series and going to options and changing the 'Gap Width' and it didn't do anything, I also tried decreasing the 'Overlap' number and nothing. I also tried making the graph area bigger and that didn't work either. I have dates on the X-axis (3 series each) and the are spaced so far apart there should be plenty of room to make the bars bigger. My bars are so close together and pin thin it's hard to read. Any suggestions would be greatly appreciated. Thanks in advance, SLKoelker |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Re-size Bars in Bar Graph
Andy you are a genius! Thank you, that is exactly what I was looking for!!!
"Andy Pope" wrote: Hi, Sounds like you want category xaxis rather than true date, which is causing the skinning columns. Right click chart and pick chart options. On the Axis tab set the X axis to Category rather than Automatic or Time series. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "SLKoelker" wrote in message ... All I want to do is make the bars bigger (they are pin thin) on my verticle (2-D) Bar Graph. I tried clicking on a series and going to options and changing the 'Gap Width' and it didn't do anything, I also tried decreasing the 'Overlap' number and nothing. I also tried making the graph area bigger and that didn't work either. I have dates on the X-axis (3 series each) and the are spaced so far apart there should be plenty of room to make the bars bigger. My bars are so close together and pin thin it's hard to read. Any suggestions would be greatly appreciated. Thanks in advance, SLKoelker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort bars in a graph | Excel Discussion (Misc queries) | |||
Can I make a graph to be a specific size? (actual graph) | Excel Discussion (Misc queries) | |||
How do I graph 2 bars with 2 different axes? | Charts and Charting in Excel | |||
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? | Charts and Charting in Excel | |||
How do I change bars into just lines on a bar graph? | Charts and Charting in Excel |