[jkamaraj]

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.

 Updated.jpg (34.72K)
Number of downloads: 1

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

Attached File(s)

•  stackedbartoplabel.rptdesign (55.85K)
  Number of downloads: 6

[jkamaraj]

mwilliams, on 23 May 2012 - 08:37 AM, said:

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

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

Attached File(s)

•  Chart.jpg (35.85K)
  Number of downloads: 0

[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";