Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
doxylady
 
Posts: n/a
Default In a chart how do I make the bars bigger?

How can I change the size of bars in a chart???
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: In a chart how do I make the bars bigger?

Here's how you can change the size of bars in a chart in Excel:
  1. First, select the chart that you want to modify by clicking on it.
  2. Next, click on the bars that you want to resize. You should see small boxes appear around the edges of the bars.
  3. Once you have selected the bars, right-click on one of them and choose "Format Data Series" from the drop-down menu.
  4. In the Format Data Series pane that appears on the right-hand side of the screen, you should see a section called "Series Options". Here, you can adjust the width of the bars by using the "Gap Width" slider.
  5. Move the slider to the right to increase the width of the bars, or to the left to decrease it. You can also enter a specific value in the box next to the slider if you want to be more precise.
  6. Once you have adjusted the width of the bars to your liking, click "Close" to apply the changes.

That's it! Your bars should now be resized to the width that you specified.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
John Mansfield
 
Posts: n/a
Default

Click once on the bars. Right-click on your mouse. Choose Selected Object
from the menu. In the Format Data Series dialog box, go to the Options tab.
You can adjust the width of the bars via the Gap Width input.

----
Regards,
John Mansfield
http://www.pdbook.com

"doxylady" wrote:

How can I change the size of bars in a chart???

  #4   Report Post  
AGC
 
Posts: n/a
Default

I had this problem myself today. I found that the gap and width sizing
weren't changing to width of the bars in my graph. It seems to have
something to do with using a date as the Category Axis Label. This was the
fix:

Go to Chart Options and select the Axes tab. Under Category (X) axis select
"Category". That should make the bars wider.


"doxylady" wrote:

How can I change the size of bars in a chart???

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display chart with three bars and one line? KB Charts and Charting in Excel 1 March 16th 05 09:09 PM
Two bars for a Chart with a Secondary Axis GregBausman Charts and Charting in Excel 3 March 2nd 05 12:03 AM
how do i make a chart using text information? danielle Excel Worksheet Functions 5 February 26th 05 10:21 PM
Bar Chart Date XAxis Thin Bars MrC Charts and Charting in Excel 8 February 15th 05 03:59 AM
How to make a stacked bar chart using time? Jon Peltier Charts and Charting in Excel 0 February 3rd 05 06:56 AM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"