Hi There.
How can I enable horizontal scroll bar for Multi-series 3D Column Chart.?
Also is there any option to set minimum size of column width?
I used "maxColWidth" to set maximum size of column.
Again
How can I enable scroll bar with Multi-series 3D Column Chart.
How can I set miminum column width?
How can I make a link for <category>?As you see on below XML, I set link within <category> element but it won't work.
Here is my XML example.
<chart caption="PBIT%20Growth%20%" palette="2" animation="1" formatNumberScale="0" numberPrefix="$" showValues="0" numDivLines="4" legendPosition="BOTTOM" aboutMenuItemLabel="About Essatto" aboutMenuItemLink="n-http://www.essatto.com.au" maxColWidth="25" >
<categories>
<category label="DEFRM1" link="j-drillDownWRfu-CDEFRM1&&&DEFRM1: Defence Regional Mgr" />
<category label="ESTDIS" link="j-drillDownWRfu-CESTDIS&&&ESTDIS: Eastern Discontinued contracts" />
<category label="ESTROH" link="j-drillDownWRfu-CESTROH&&&ESTROH: Eastern Region Overheads" />
<category label="NSWRM1" link="j-drillDownWRfu-CNSWRM1&&&NSWRM1: NSW FS Eurest/Scolarest" />
<category label="QLDR00" link="j-drillDownWRfu-CQLDR00&&&QLDR00: QLD Remote" />
<category label="QLDRM1" link="j-drillDownWRfu-CQLDRM1&&&QLDRM1: QLD FS Eurest/Scolarest" />
<category label="SARM01" link="j-drillDownWRfu-CSARM01&&&SARM01: SA Food Services" />
<category label="SA_R00" link="j-drillDownWRfu-CSA_R00&&&SA_R00: SA Remote Services" />
<category label="VICR00" link="j-drillDownWRfu-CVICR00&&&VICR00: VIC Remote" />
<category label="VICRM1" link="j-drillDownWRfu-CVICRM1&&&VICRM1: VIC FS Eurest/Scolarest" />
<category label="WARM01" link="j-drillDownWRfu-CWARM01&&&WARM01: WA Food Services" />
</categories>
<dataset seriesName="2008 Actual">
<set toolText="DEFRM1: Defence Regional Mgr{br}2008 Actual : -41.5402300527601" value="-41.5402300527601" link="j-drillDownWRfu-CDEFRM1&&&DEFRM1: Defence Regional Mgr"/>
<set toolText="ESTDIS: Eastern Discontinued contracts{br}2008 Actual : 0" value="0" link="j-drillDownWRfu-CESTDIS&&&ESTDIS: Eastern Discontinued contracts"/>
<set toolText="ESTROH: Eastern Region Overheads{br}2008 Actual : 9.02672144643913" value="9.02672144643913" link="j-drillDownWRfu-CESTROH&&&ESTROH: Eastern Region Overheads"/>
<set toolText="NSWRM1: NSW FS Eurest/Scolarest{br}2008 Actual : -481.113286967607" value="-481.113286967607" link="j-drillDownWRfu-CNSWRM1&&&NSWRM1: NSW FS Eurest/Scolarest"/>
<set toolText="QLDR00: QLD Remote{br}2008 Actual : -60.9781020006951" value="-60.9781020006951" link="j-drillDownWRfu-CQLDR00&&&QLDR00: QLD Remote"/>
<set toolText="QLDRM1: QLD FS Eurest/Scolarest{br}2008 Actual : -798.610074714215" value="-798.610074714215" link="j-drillDownWRfu-CQLDRM1&&&QLDRM1: QLD FS Eurest/Scolarest"/>
<set toolText="SARM01: SA Food Services{br}2008 Actual : -551.541826670124" value="-551.541826670124" link="j-drillDownWRfu-CSARM01&&&SARM01: SA Food Services"/>
<set toolText="SA_R00: SA Remote Services{br}2008 Actual : 56.852393800736" value="56.852393800736" link="j-drillDownWRfu-CSA_R00&&&SA_R00: SA Remote Services"/>
<set toolText="VICR00: VIC Remote{br}2008 Actual : 87.1320308485965" value="87.1320308485965" link="j-drillDownWRfu-CVICR00&&&VICR00: VIC Remote"/>
<set toolText="VICRM1: VIC FS Eurest/Scolarest{br}2008 Actual : -418.640518767024" value="-418.640518767024" link="j-drillDownWRfu-CVICRM1&&&VICRM1: VIC FS Eurest/Scolarest"/>
<set toolText="WARM01: WA Food Services{br}2008 Actual : -1237.00245363715" value="-1237.00245363715" link="j-drillDownWRfu-CWARM01&&&WARM01: WA Food Services"/>
</dataset>
<dataset seriesName="2009 Actual">
<set toolText="DEFRM1: Defence Regional Mgr{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CDEFRM1&&&DEFRM1: Defence Regional Mgr"/>
<set toolText="ESTDIS: Eastern Discontinued contracts{br}2009 Actual : 0" value="0" link="j-drillDownWRfu-CESTDIS&&&ESTDIS: Eastern Discontinued contracts"/>
<set toolText="ESTROH: Eastern Region Overheads{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CESTROH&&&ESTROH: Eastern Region Overheads"/>
<set toolText="NSWRM1: NSW FS Eurest/Scolarest{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CNSWRM1&&&NSWRM1: NSW FS Eurest/Scolarest"/>
<set toolText="QLDR00: QLD Remote{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CQLDR00&&&QLDR00: QLD Remote"/>
<set toolText="QLDRM1: QLD FS Eurest/Scolarest{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CQLDRM1&&&QLDRM1: QLD FS Eurest/Scolarest"/>
<set toolText="SARM01: SA Food Services{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CSARM01&&&SARM01: SA Food Services"/>
<set toolText="SA_R00: SA Remote Services{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CSA_R00&&&SA_R00: SA Remote Services"/>
<set toolText="VICR00: VIC Remote{br}2009 Actual : 0" value="0" link="j-drillDownWRfu-CVICR00&&&VICR00: VIC Remote"/>
<set toolText="VICRM1: VIC FS Eurest/Scolarest{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CVICRM1&&&VICRM1: VIC FS Eurest/Scolarest"/>
<set toolText="WARM01: WA Food Services{br}2009 Actual : 100" value="100" link="j-drillDownWRfu-CWARM01&&&WARM01: WA Food Services"/>
</dataset>
<dataset seriesName="2009 vs 2008">
<set toolText="DEFRM1: Defence Regional Mgr{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CDEFRM1&&&DEFRM1: Defence Regional Mgr"/>
<set toolText="ESTDIS: Eastern Discontinued contracts{br}2009 vs 2008 : 0" value="100" link="j-drillDownWRfu-CESTDIS&&&ESTDIS: Eastern Discontinued contracts"/>
<set toolText="ESTROH: Eastern Region Overheads{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CESTROH&&&ESTROH: Eastern Region Overheads"/>
<set toolText="NSWRM1: NSW FS Eurest/Scolarest{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CNSWRM1&&&NSWRM1: NSW FS Eurest/Scolarest"/>
<set toolText="QLDR00: QLD Remote{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CQLDR00&&&QLDR00: QLD Remote"/>
<set toolText="QLDRM1: QLD FS Eurest/Scolarest{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CQLDRM1&&&QLDRM1: QLD FS Eurest/Scolarest"/>
<set toolText="SARM01: SA Food Services{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CSARM01&&&SARM01: SA Food Services"/>
<set toolText="SA_R00: SA Remote Services{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CSA_R00&&&SA_R00: SA Remote Services"/>
<set toolText="VICR00: VIC Remote{br}2009 vs 2008 : 0" value="100" link="j-drillDownWRfu-CVICR00&&&VICR00: VIC Remote"/>
<set toolText="VICRM1: VIC FS Eurest/Scolarest{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CVICRM1&&&VICRM1: VIC FS Eurest/Scolarest"/>
<set toolText="WARM01: WA Food Services{br}2009 vs 2008 : 100" value="100" link="j-drillDownWRfu-CWARM01&&&WARM01: WA Food Services"/>
</dataset>
<dataset seriesName="Bud 2009 Var">
<set toolText="DEFRM1: Defence Regional Mgr{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CDEFRM1&&&DEFRM1: Defence Regional Mgr"/>
<set toolText="ESTDIS: Eastern Discontinued contracts{br}Bud 2009 Var : -100" value="0" link="j-drillDownWRfu-CESTDIS&&&ESTDIS: Eastern Discontinued contracts"/>
<set toolText="ESTROH: Eastern Region Overheads{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CESTROH&&&ESTROH: Eastern Region Overheads"/>
<set toolText="NSWRM1: NSW FS Eurest/Scolarest{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CNSWRM1&&&NSWRM1: NSW FS Eurest/Scolarest"/>
<set toolText="QLDR00: QLD Remote{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CQLDR00&&&QLDR00: QLD Remote"/>
<set toolText="QLDRM1: QLD FS Eurest/Scolarest{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CQLDRM1&&&QLDRM1: QLD FS Eurest/Scolarest"/>
<set toolText="SARM01: SA Food Services{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CSARM01&&&SARM01: SA Food Services"/>
<set toolText="SA_R00: SA Remote Services{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CSA_R00&&&SA_R00: SA Remote Services"/>
<set toolText="VICR00: VIC Remote{br}Bud 2009 Var : -100" value="0" link="j-drillDownWRfu-CVICR00&&&VICR00: VIC Remote"/>
<set toolText="VICRM1: VIC FS Eurest/Scolarest{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CVICRM1&&&VICRM1: VIC FS Eurest/Scolarest"/>
<set toolText="WARM01: WA Food Services{br}Bud 2009 Var : 0" value="0" link="j-drillDownWRfu-CWARM01&&&WARM01: WA Food Services"/>
</dataset>
<dataset seriesName="Forecast A 2009 Var">
<set toolText="DEFRM1: Defence Regional Mgr{br}Forecast A 2009 Var : 87.491124852682" value="87.491124852682" link="j-drillDownWRfu-CDEFRM1&&&DEFRM1: Defence Regional Mgr"/>
<set toolText="ESTDIS: Eastern Discontinued contracts{br}Forecast A 2009 Var : -12.508875147318" value="87.491124852682" link="j-drillDownWRfu-CESTDIS&&&ESTDIS: Eastern Discontinued contracts"/>
<set toolText="ESTROH: Eastern Region Overheads{br}Forecast A 2009 Var : 67.0342603914557" value="67.0342603914557" link="j-drillDownWRfu-CESTROH&&&ESTROH: Eastern Region Overheads"/>
<set toolText="NSWRM1: NSW FS Eurest/Scolarest{br}Forecast A 2009 Var : 19.4225481827539" value="19.4225481827539" link="j-drillDownWRfu-CNSWRM1&&&NSWRM1: NSW FS Eurest/Scolarest"/>
<set toolText="QLDR00: QLD Remote{br}Forecast A 2009 Var : 62.7931429508183" value="62.7931429508183" link="j-drillDownWRfu-CQLDR00&&&QLDR00: QLD Remote"/>
<set toolText="QLDRM1: QLD FS Eurest/Scolarest{br}Forecast A 2009 Var : 16.6157785063126" value="16.6157785063126" link="j-drillDownWRfu-CQLDRM1&&&QLDRM1: QLD FS Eurest/Scolarest"/>
<set toolText="SARM01: SA Food Services{br}Forecast A 2009 Var : 22.6010307329543" value="22.6010307329543" link="j-drillDownWRfu-CSARM01&&&SARM01: SA Food Services"/>
<set toolText="SA_R00: SA Remote Services{br}Forecast A 2009 Var : 179.604509280309" value="179.604509280309" link="j-drillDownWRfu-CSA_R00&&&SA_R00: SA Remote Services"/>
<set toolText="VICR00: VIC Remote{br}Forecast A 2009 Var : 79.604509280309" value="179.604509280309" link="j-drillDownWRfu-CVICR00&&&VICR00: VIC Remote"/>
<set toolText="VICRM1: VIC FS Eurest/Scolarest{br}Forecast A 2009 Var : 21.0553801307689" value="21.0553801307689" link="j-drillDownWRfu-CVICRM1&&&VICRM1: VIC FS Eurest/Scolarest"/>
<set toolText="WARM01: WA Food Services{br}Forecast A 2009 Var : 87.491124852682" value="87.491124852682" link="j-drillDownWRfu-CWARM01&&&WARM01: WA Food Services"/>
</dataset>
<styles>
<definition>
<style type="font" name="CaptionFont" color="666666" size="12" />
<style type="font" name="SubCaptionFont" bold="0" />
<style name="myCaptionAnim" type="animation" param="_y" easing="Strong" start="0" duration="1" />
</definition>
<application>
<apply toObject="caption" styles="CaptionFont" />
<apply toObject="SubCaption" styles="SubCaptionFont" />
<apply toObject="Caption" styles="myCaptionAnim" />
</application>
</styles>
</chart>
Thank you