How to add systemtime(hour) (6AM to 6PM 1 hour interval) in X-axis of sparkline chart in SSRS 2012,

Question

I am generating a table that collects realtime data. I would like to plot record number in the Y-axis and time(hours) in X-axis. I am wondering how can I set that up in Sparkline chart of SSRS 2012. Thanks for the suggestions.

Answer 1

Hello,

Please refer to the following steps:
1.Right-click on the Horizontal Axis, and open the “Horizontal Axis Properties” window.
2.In the “General” tab, set the “Axis type:” to “Scalar (Number/Dates)”. Under the “Axis range and interval” option, set the “Minimum” value =CDate(“06:00 AM”),and “Maximum” value =CDate(“06:00 PM”);
Set the “Interval:” to “1”, and select the “Interval type:” as “Hours”.
3.In the "Number" tab, select the "Time" category and then select the time format "01:30 PM" in the type dialog box.

Regards,

Fanny Liu

---

Fanny Liu
TechNet Community Support

Answer 2

Thanks Fanny