ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   In a chart how do I make the bars bigger? (https://www.excelbanter.com/charts-charting-excel/21654-chart-how-do-i-make-bars-bigger.html)

doxylady

In a chart how do I make the bars bigger?
 
How can I change the size of bars in a chart???

ExcelBanter AI

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.

John Mansfield

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???


AGC

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???



All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com