Multiple Y Series value with grouping

Nikhil Mahajan

<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">I have created a scripted dataset which <span style="font-size:12.8000001907349px;"> has 4 fields:-</span></div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"> </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">Factory, SaleAmount, QuoteAmount and Year</div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"> </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">In this dataset I have created a SaleVsQuoted column chart with following configuration:-</div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">
<ul><li>Value y- Series-1 : SaleAmount</li>
<li>Value y: Series-2 - QuoteAmout</li>
<li>Category x Axis:- Factory</li>
<li>Optional Y Series Grouping:- Year</li>
</ul></div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">Now the charts seems to rendering properly but the issue is for the year based grouping I am getting four values</div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"><strong>2013, 2014, 2013, 2014</strong> in the <strong>legend</strong>. Each for Quoted and Sales I think.</div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"> </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">Now how do I identify as which bar/column in the chart represents for Sales of that year and which <span style="font-size:12.8000001907349px;">represents </span>Quotes for that year.</div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"> </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">Is there a way I can change Legend labels depending upon the <strong>Values Y series</strong> and <strong>Year</strong> together. </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">i.e I want legend as </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"> </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"><strong>2014 SaleAmount,  </strong><strong>2014 QuoteAmount, </strong><strong>2013 SaleAmount, </strong><strong>2013 QuoteAmount </strong></div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"> </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">instead of simple year in the legend</div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;"> </div>
<div style="font-family:arial, sans-serif;font-size:12.8000001907349px;">Thanks</div>

mwilliams

In a chart like you describe, the legend would be split with the series title above the legend entries. If you haven't changed these in your chart, they'd still say Series 1 and Series 2. You could make it so these say SaleAmount and QuoteAmount by going to the "Series" section in the "Format Chart" tab of the chart editor and changing the name of each series to the appropriate value in the text boxes associated with each series. Let me know if this doesn't solve your issue.