sql server - Chart line title in SSRS -
i'm working on ssrs line charts. in single graph have 4 lines, each 2 of comparisions. woud add title each line in chart below. understand data without checking color code of each lines axes definitions located @ end of chart. please guide me how achieve it.
update: please find requirement question below in excel. similar in ssrs
https://superuser.com/questions/807068/how-to-display-series-name-inside-bars-of-stacked-bar-chart
you can set label property of series show helper text conditionally specific x-axis value.
click serie need label, in case [sum(cancelations)] can see in below screenshot.
press f4
, properties window appear. in property window, search label node , expand it, this:
in label
property have use expression determine have place label, in case i've used:
=iif(fields!day.value="123", "cancelation", nothing )
this expression says, show cancelation
label when x-axis label equal 123
, if day field (x-axis) not 123
shows nothing.
the same logic if want label appearing @ beginning of line, in case have use first value in x-axis.
=iif(fields!day.value="2", "t-2", nothing )
it says if day.value equal 2
show t-2
label. otherwise show nothing.
i've created example.
alternatively, can use tooltips if generating report in interactive format mhtml. note tooltip appears when pass mouse on line.
note have set
visible
propertytrue
pointed in screenshot.
let me know if helps.
Comments
Post a Comment