Combining multiple Category (X) Series values on one bar

CodeRookie

<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>

Clement Wong

<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>