Dynamics Community Forum Thread Details

How to make bars separated and horizontal in chart xml

I have two sets of bars: (1) Gross Margin This vs Last Year and (2) Services Margin This vs Last Year. I want to make them horizontal and also separate the two sets of bars so they're not all clumped together. Is this possible? I created this in XML in order to get the LYTD comparisons.

8117.grossmarginchart.png

<presentationdescription>
    <Chart Palette="None" PaletteCustomColors="91,151,213; 237,125,49; 160,116,166; 255,192,0; 68,114,196; 112,173,71; 37,94,145; 158,72,14; 117,55,125; 153,115,0; 38,68,120; 67,104,43; 124,175,221; 241,151,90; 186,144,192; 255,205,51; 105,142,208; 140,193,104; 50,125,194; 210,96,18; 150,83,159; 204,154,0; 51,90,161; 90,138,57;">
      <Series>
        <Series LegendText="This Year YTD" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" />
        <Series LegendText="Last Year LYTD" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" YAxisType="Primary" />
        <Series LegendText="ThisYear ServicesMargin" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" />
        <Series LegendText="LastYear ServicesMargin" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" />
      </Series>
      <ChartAreas>
        <ChartArea BorderColor="White" BorderDashStyle='Solid'>
          <AxisY LabelAutoFitMinFontSize='8' TitleForeColor='59, 59, 59' TitleFont='{0}, 10.5px' LineColor='165, 172, 181' IntervalAutoMode='VariableCount'>
            <MajorGrid LineColor='239, 242, 246' />
            <MajorTickMark LineColor='165, 172, 181' />
            <LabelStyle Font='{0}, 10.5px' ForeColor='59, 59, 59' />
          </AxisY>
          <AxisX LabelAutoFitMinFontSize='8' TitleForeColor='59, 59, 59' TitleFont='{0}, 10.5px' LineColor='165, 172, 181' IntervalAutoMode='VariableCount'>
            <MajorTickMark LineColor='165, 172, 181' />
            <MajorGrid LineColor='Transparent' />
            <LabelStyle Font='{0}, 10.5px' ForeColor='59, 59, 59' />
          </AxisX>
          <AxisY2 LabelAutoFitMinFontSize='8' TitleForeColor='59, 59, 59' TitleFont='{0}, 10.5px' LineColor='165, 172, 181' IntervalAutoMode='VariableCount'>
            <MajorGrid LineColor='239, 242, 246' />
            <MajorTickMark LineColor='165, 172, 181' />
            <LabelStyle Font='{0}, 10.5px' ForeColor='59, 59, 59' />
          </AxisY2>
        </ChartArea>
      </ChartAreas>
      <Titles>
        <Title Alignment='TopLeft' DockingOffset='-3' Font='{0}, 13px' ForeColor='59, 59, 59' />
      </Titles>
      <Legends>
        <Legend Alignment='Center' LegendStyle='Table' Docking='right' IsEquallySpacedItems='True' Font='{0}, 11px' ShadowColor='0, 0, 0, 0' ForeColor='59, 59, 59' />
      </Legends>
    </Chart>
  </presentationdescription>

Quick Links