Gazoo

Members
 View Profile  See their activity

  • Content count

    2

  • Joined

  • Last visited

About Gazoo

  • Rank
    Forum Newbie
  1. What can I do about squished stacked bar text when the stacked portion of the bar is relatively small... Is there a way to place the text outside of the bar with a callout arrow, or stagger the horizontal positioning of the text so that is displays properly, or even is there a way I can show all 3 values of the stacked chart on tooltip on hover such as "CAT1: X, CAT2: Y, CAT3: Z" Probably in that order would work for me... see attached.
  2. 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!