title: How to put bar chart legend values inside the bar itself (so I can remove the legend)?
body: <p><em>I apologize in advance for the ambiguity here. I don't want to expose any potential intellectual property so I have to generalize.</em></p>
  
  <p>I have a bar chart in CR 2013 which shows (top 5) sums of [amount] on the data axis and each bar represents a different [category 1].</p>
  
  <p>The base query is pulling the [amount] from a pre-summarized table, based on a date parameter passed to the query. It is not very complicated. The actual query joins out to tables to pull in names for the ids, but in a nutshell:</p>
  
  <pre><code>declare @end_date varchar(15) = '{?endDate}'; -- passed in from main report
  
  select *
  from [summary table] s 
  where s.[summary date] = @end_date
  </code></pre>
  
  <p>The base data from the query looks like this:</p>
  
  <pre><code>[category 1 name &amp; id] | ... | [category n name &amp; id] | [amount] | [..other fields...] | [summary date]
  </code></pre>
  
  <p>with rows for each combination of all [category] fields that has data on the [summary date].</p>
  
  <p><em>(This is a very robust, mostly 3nf database; the [category n] columns are all foreign keys to specific objects, e.g. [department_id], [facility_id], [user_id], etc. I don't want to give the impression that this is an EAV schema or something like that.)</em></p>
  
  <p>So my bar chart is set up like this:</p>
  
  <p>On change of <code>command.[category 1 name &amp; id]</code> show values <code>Sum of command.[amount]</code></p>
  
  <p>I have "show value" checked for the Data Points.</p>
  
  <p>What I would like to accomplish is to move the "Legend" labels (the values of [category 1 name &amp; id]) to the bars themselves, rather than using the legend. I can't seem to find a way to do this easily.</p>