Compact bars if no data for series value

[Gazoo]

Hi, I would love to know if there's a way to compact the baries on multi series chart.

 

If I have values for all categories and series, it looks fine, but if I have some null values, or empty values it shows the large gaps where data once was.

 

I'm open to any logical solution really. Ideally I would like the spaces between missing values to be gone and the chart to center and compact.

 

See screenshot, some departments only have series data in one series, not all 5, and is off, and has gaps.

 

Here is XML.

 

<?xml version="1.0" encoding="UTF-8"?>
<chart xAxisName="Department" showLegend="1" yAxisName="Turnover" useRoundEdges="0" bgColor="FFFFFF" canvasBgColor="FFFFFF, FFFFFF" showBorder="0" canvasBorderThickness="1" canvasBorderColor="dddddd" palette="2" shownames="1" decimals="1" chartRightMargin="20" slantLabels="1">
   <categories>
      <category label="Client Services" />
      <category label="Corporate HQ" />
      <category label="Operations" />
      <category label="Other" />
      <category label="Recruiting" />
   </categories>
   <dataset seriesName="0-30 days">
      <set value="4"   />
      <set value=""   />
      <set value=""   />
      <set value=""   />
      <set value=""   />
   </dataset>
   <dataset seriesName="60+ days">
      <set value=""   />
      <set value=""   />
      <set value=""   />
      <set value=""   />
      <set value="4"   />
   </dataset>
   <dataset seriesName="1+ yrs">
      <set value="24"   />
      <set value=""   />
      <set value="4"   />
      <set value=""   />
      <set value="4"   />
   </dataset>
   <dataset seriesName="2+ yrs">
      <set value="4"   />
      <set value="4"   />
      <set value=""   />
      <set value="4"   />
      <set value=""   />
   </dataset>
   <dataset seriesName="3+ yrs">
      <set value="28"   />
      <set value=""   />
      <set value=""   />
      <set value=""   />
      <set value="4"   />
   </dataset>
   <styles>
      <definition>
         <style name="valuesStyle" type="font" size="11" color="454545" bold="1" />
         <style name="axisStyle" type="font" size="12" color="454545" bold="0" />
         <style name="mainAxisStyle" type="font" size="13" color="bd3500" bold="1" />
         <style name="trendStyle" type="font" size="11" color="BD3500" bold="0" />
      </definition>
      <application>
         <apply toObject="DataValues" styles="valuesStyle" />
         <apply toObject="XAXISNAME" styles="mainAxisStyle" />
         <apply toObject="YAXISNAME" styles="mainAxisStyle" />
         <apply toObject="DATALABELS" styles="axisStyle" />
         <apply toObject="YAXISVALUES" styles="axisStyle" />
         <apply toObject="VTRENDVALUES" styles="trendStyle" />
      </application>
   </styles>
</chart>

Also, side related, is there a way I could just pass the data I have (not including the null values) so for instance...

 

Instead of passing

   <categories>
      <category label="Client Services" />
      <category label="Corporate HQ" />
      <category label="Operations" />
      <category label="Other" />
      <category label="Recruiting" />
   </categories>
   <dataset seriesName="0-30 days">
      <set value="4"   />
      <set value=""   />
      <set value=""   />
      <set value=""   />
      <set value=""   />
   </dataset>

Can I pass something to the effect of 

   <dataset seriesName="0-30 days">
      <set value="4" Category="Client Services"  />
   </dataset>

The execution doesn't matter as much, I can alter the data as needed.

 

Thanks in advance!

[Guest Sumedh]

Hello,

 

You cannot make the chart compact.

 

Depending on the category elements, chart allocates the spaces for plots whether it null or defined.