BusinessObjects Board

Space between bars in a barchart

other Xcelsius - Crystal Dashboard Design
#1

I’m trying to add some spaces between the bar’s in a Combination Chart.

So far I’ve found out to add a dummy column with 0 values and add those as a series… but the result is a little bit disappointing…

  • your horizontal axes labels are now not aligned anymore (and you cannot change the offset)
  • the dummy column also appears in the legend
    Barchart_problem.PNG

Tiny :netherlands: (BOB member since 2004-11-10)

#2

Your on the right track. Use only two series… one for the bars and one for the line. to inject additional space between two bars leave a zero value in between the actual values. Example:


	Mon		Wed		Fri		Sun 	
WA	1	0	2	0	3	0	4	0
WC	1	2	3	4	5	6	7	8

WA is Bar series
WC is line
Days at top are category labels (X-axis)

The bar space is made by inserting 0 values in “Data” not adding series. X axis labels are not seen if left blank such as missing Tuesday, Thursday, etc…
If needed you can use additional bar series just keep the data in the same pattern as you use for your other bar data - blank columns should be aligned where you have used zeros for spaces.

datawizard (BOB member since 2015-01-20)