Combining multiple Category (X) Series values on one bar

CodeRookie
edited February 11, 2022 in Analytics #1
<p>Good morning, all!  Another week brings another chart modification request from one of my end users.  This time, they've asked if it is possible to make a bar chart that has multiple values (4) on the Category (X) Series that only has one bar that is broken down into those Series values (see pic for example).</p>
<p> </p>
<p>

Comments

  • <p>Is the attached what you are looking for?</p>
    <p> </p>
    <p>Items changed in your design:</p>
    <p> </p>
    <ol><li> Under <em>Select Chart Type</em>, changed chart type to Bar > Stacked</li>
    <li> Under <em>Select Data</em>, changed <strong>Catetgory (X) Series</strong> to 'Stacked' (with single quotes)</li>
    <li> Under <em>Select Data</em>, dragged row["first_material_type"] to <strong>Optional Y Series Grouping</strong></li>
    <li> Under <em>Format Chart > Series</em>, change <strong>Color By</strong> from Categories to Value Series</li>
    </ol><p> </p>
    <p>If not so simple, please provide more sample data, and expected output.</p>
    Warning No formatter is installed for the format ipb
  • <p>Perfect!  Thanks, Clement!!</p>