Charts with Multiple Series = Weird spacing

  • 1
  • Problem
  • Updated 3 years ago
  • Not a Problem
I've created a column chart that displays 8 different "series," grouped into two groups. The data seems to behave properly, but the chart displays the columns with an odd spacing. The category is using the "owner name" which, doesn't exist for one of the groups, thus the null label on the axis.

Is there an easy way to fix this spacing issue?
Photo of Josh Merritt

Josh Merritt

  • 918 Points 500 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
I'm pretty sure that each of the 8 series is taking up space.  It simply is that in the first category,  series 1 - 4 are 0 and in the second category series 5-8 are 0. 

Not knowing your data model, its impossible to tell for sure,  but if you could ouput this as two series, with splits in each series,  this might give you what you are after. 
Photo of Josh Merritt

Josh Merritt

  • 918 Points 500 badge 2x thumb
Thanks, Rob. Unfortunately, I can't get all these values in a single model/series due to the way these values need to be calculated. 

I discovered if I alternated the two "groups"/series, it worked to make it look better. It's still got the blanks that you mentioned, but at least they're equally spaced now.