ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a histogram with no space between bars? (https://www.excelbanter.com/charts-charting-excel/49424-how-do-i-create-histogram-no-space-between-bars.html)

Ann

How do I create a histogram with no space between bars?
 
I am using the histogram with the data anylsis tool from microsoft office. I
am trying to create a histogram without space between the bars.

Andy Pope

Hi,

To reduce the gap between columns double click the column and on the
Option tab of the format dialog set the Gap Width to zero.

Cheers
Andy

Ann wrote:
I am using the histogram with the data anylsis tool from microsoft office. I
am trying to create a histogram without space between the bars.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Mike Middleton

Ann -

I am using the histogram with the data anylsis tool from microsoft office.
I am trying to create a histogram without space between the bars. <


If you would like a histogram with no space between bars (Gap Width = zero)
and with axis labels below the tick marks (instead of centered under the
bars), try my free Better Histogram add-in available at www.treeplan.com.

- Mike
www.mikemiddleton.com




All times are GMT +1. The time now is 06:02 AM.

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