SSRS chart should look like my excel chart

0
votes

I am doing an SSRS report which needs to have a chart that looks like this

Excel chart

and so far on my ssrs report I have this

SSRS chart

how could I make my ssrs chart the same on my excel chart?

Thank you in advance

1
reporting-servicescharts

1 Answers

0
votes

First thing is to put all your data together. You want to compare different years with the same date. You'll need to change your date field to just use the month and day:

=FORMAT(FIELDS!YourDateField.Value, "MM-dd")

For the axis label, use the Day of the Week:

=FORMAT(FIELDS!YourDateField.Value, "dw")

enter image description here

For your markers, go to Series Properties->Markers tab and set Marker Type to Auto to let SSRS assign a different type to each. If each year is a different series, you can assign them individually.

You can right-click on an Axis and go to properties to format them to look more like the Excel version.

There's a bit more differences but mostly formatting.