Bar chart with one series as marker

piramanayagam.td

<p>I have created a bar chart with 3 series. In which the first two series are absolute values in Rs. The third series is the share of series 1 in series 2. For eg (Series1 value/Series 2 value * 100). I have configured series 1 and series 2 as bar and series 3 as line. Now the problem is, as the series 3 values are in % they are almost overlapping with the labels/bars of the other two series. Is there is any method to show the series 3 values on the top without considering the axis? Kindly help. </p>

jfranken

<p>One option is to add a separate axis for the third series.  On the "Select Chart Type" tab, go to "Multiple Y Axis" and choose "Secondary Axis".  On the "Select Data" tab, choose the third series for Y Axis 2 and scale it appropriately.</p>