ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Continuous data in a histogram (https://www.excelbanter.com/excel-discussion-misc-queries/170850-continuous-data-histogram.html)

AlBourne88

Continuous data in a histogram
 
I have continuous data and wish to get a histogram where the bars touch
eachother, due to the fact that in continuous data this has to occur.
However, when I have constructed a histogram the bars don't touch eachother.
Can anyone tell me how i can get the bars to touch eachother on a histogram???

Thanks

Jon Peltier

Continuous data in a histogram
 
Double click on a column, and on the Options tab of the Format Series dialog
that pops up, change Gap Width to zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AlBourne88" wrote in message
...
I have continuous data and wish to get a histogram where the bars touch
eachother, due to the fact that in continuous data this has to occur.
However, when I have constructed a histogram the bars don't touch
eachother.
Can anyone tell me how i can get the bars to touch eachother on a
histogram???

Thanks





All times are GMT +1. The time now is 12:57 AM.

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