How to set the Y series value as title to bars ?

I need to design a chart report for our HR that will display two Y Value Series for every month of the quarter. The two Y Value series are "INTERMITTTENT" and "CONTINUOUS" leaves. Each bar is also stacked by grouping based on the reason of the leave.

I need to display INT and CON above the bars as in the attached picture. If I enable the value data I get the number of leaves dispalyd in the stacked bars and if I select value series name then I get actual reason that is coming in the legend. I do not want either. I need to display the titel of the Y value seris which is INT and CON. How can I do that. Thank you for any inputs.

Find more posts tagged with

Comments

mwilliams

The difficult part is going to be figuring out which label is the top label for each bar, so you don't hide it. If I'll talk to a colleague of mine to see if he knows a way. I'll report back if I find something. Hopefully someone else has done this already and will have an answer for you.

mwilliams

Take a look at this example. It was made in 3.7.2.

jkamaraj

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="101234" data-time="1337787467" data-date="23 May 2012 - 08:37 AM">
Take a look at this example. It was made in 3.7.2. </blockquote>
Thanks Williams. I will take a look at the design. In the meantime we resolved the issue by adding the title in the X-axis test as in the attached figure. Not as neat as putting on the top of the bar but the users are ok with this. 
 
Regards, 
Kamaraj

jkamaraj

used the following code for the Category X-Series in Select Data tab of the Edit Chart window
if (BirtStr.left(row["MONTH_YEAR"] ,2) == "01")
"CON INT \n 01/2012";
else if (BirtStr.left(row["MONTH_YEAR"] ,2) == "02")
"CON INT \n 02/2012";
else if (BirtStr.left(row["MONTH_YEAR"] ,2) == "03")
"CON INT \n 03/2012";