 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Stacked Column gap width
I have a stacked column graph and I have set the gap width to 0. There is, however, still space between the stacked columns. The gap looks to be about twice as wide as the column themselves. Any idea why? The column overlap is set to 100. The Gap Width is set to 0. In case it matters, the X axis is a time scale, all axis settings are automatic. It looks like both ClusteredColumn and StackedColumn graph types have some intra-cluster spacing that cannot be eliminated... Brian Herbert Withun When you use a time-scale axis, it creates categories for each day (all days). The time-scale is intended to space your categories as a function of the dates, whereas a regular x-axis puts the categories evenly spaced on the x axis. So unless your dates are consecutive, there will be categories for the dates where there is no data, hence the space between them, even with the gap width set to 0. With the gap width set to 0, only consecutive dates will have no gap.  SignatureRegards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- >I have a stacked column graph and I have set the gap width to 0. > There is, however, still space between the stacked columns. [quoted text clipped - 12 lines] > > Brian Herbert Withun
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.