locked
Adding values to a stacked chart RRS feed

  • Question

  • This will probably be straightforward for someone out there but I'm struggling with this as I don't use charts on a regular basis. I have created the following chart using the Chart Wizard in CRM to access the Cases entity and list the Cases logged by the month and split by their priority.

    So far so good. But what I also need is to have a count on each of the colours on each of the bars so for Feb 2014, the blue section would have a "9" over it, the red section would have a "10" over it and the green sections would have a "6" over it. I hope I'm making sense...

    I've had a go at altering the XML to let me do this with one of 2 results. Either it imports but makes no difference to its display or it errors when importing. As I say, this is something that I do from time to time but have got a bit stuck here. My XML is below and any help would be much appreciated.

    <visualization>
      <visualizationid>{}</visualizationid>
      <name>MyChart</name>
      <primaryentitytypecode>incident</primaryentitytypecode>
      <datadescription>
        <datadefinition>
          <fetchcollection>
            <fetch mapping="logical" aggregate="true">
              <entity name="incident">
                <attribute groupby="true" alias="_Date_Logged" name="createdon" dategrouping="month" />
                <attribute alias="_Total" name="incidentid" aggregate="count" />
                <attribute name="prioritycode" groupby="true" alias="_CRMAutoGen_groupby_column_Num_14" />
              </entity>
            </fetch>
          </fetchcollection>
          <categorycollection>
            <category alias="_Date_Logged">
              <measurecollection>
                <measure alias="_Total" />
              </measurecollection>
            </category>
          </categorycollection>
        </datadefinition>
      </datadescription>
      <presentationdescription>
        <Chart Palette="None" PaletteCustomColors="55,118,193; 197,56,52; 149,189,66; 117,82,160; 49,171,204; 255,136,35; 97,142,206; 209,98,96; 168,203,104; 142,116,178; 93,186,215; 255,155,83">
          <Series>
            <Series ChartType="StackedColumn" IsValueShownAsLabel="False" 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>
            </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>
      <isdefault>false</isdefault>
    </visualization>

    Friday, March 7, 2014 10:11 AM

Answers