Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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



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
Count Continuous data between cells Lloyd Excel Worksheet Functions 7 September 21st 07 08:28 AM
Multiple Selection of Non-Continuous Data [email protected] Excel Worksheet Functions 3 January 15th 07 07:10 PM
I was creating a histogram; now i have data but no histogram. ShannonMills3 Excel Worksheet Functions 0 June 14th 06 12:03 AM
How to Histogram w/o raw data but histogram Table on Excel 2005 Charts and Charting in Excel 1 February 1st 06 06:48 AM
3D Chart with Continuous Data in all three Axes Barb Reinhardt Charts and Charting in Excel 3 January 10th 05 07:09 PM


All times are GMT +1. The time now is 03:15 AM.

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"