SSRS Bar Chart 2 Values on 1 Axis

Hi Everyone,

Whatever I do, I can't get what I want to achieve.
Looking at the rendered graph in Doc1.docx, I want to see the value as a Red Dot or Diamond or Star or whatever for the value of Last Years Points (Light Blue Line) on the same axis as the bar for This Years Points (Dark Blue Line).

I have tried a Stacked bar, that is wrong, because I end up with the "Total Value" as the length of the Line, IE, This Yr + Last Yr. The only redeeming feature with this option is the data is on one line.

I have tried making my Last Years Points a line graph, to no avail. When I do I get both columns changing to a line. Not what I want.

I have tried making the Last Years Points  Secondary Data on the Y axis. This just puts a scale in on the top of my graph. I still see 2 columns.

Any suggestions?

Thanks
Tony
Doc1.docx
LVL 12
Tony303Asked:
Who is Participating?
 
ValentinoVBI ConsultantCommented:
Okay, as far as I understood your question you want the two bars to overlap each other and not add up as the stacked bar indeed does.  It's possible through the Properties (F4 if you don't see the window).  Click the orange bar to select your second Chart Series.  The top of the Properties window should now show something like "LastYearPoints Chart Series".

Locate the DrawSideBySide property in the CustomAttributes property group and set it to False.

Now on to the second part of your request: "I want to see the value as a Red Dot or Diamond or Star or whatever"

That can all be done through the regular properties window so right-click the orange bar and select Series Properties.  Switch to the Markers page and select your desired Marker Type: square, circle, diamond, ....  You can set the Marker Color to red if desired, and you'll also want to increase Marker Size to something like 15pt (try out to know for sure).  This adds a marker to the bar.

To conclude we need to hide the bar.  Switch to the Fill page in the Series Properties window and set Color to No Color.

That's it, you should now have a marker on top of your dark blue bar!
0
 
Tony303Author Commented:
Absolutely perfect.
The trick was the Custom Attributes, Side by Side. Not a real easy property to find Mr Microsoft.

Anyway, then the rest was as I had played with before.

Output attached.

Thank you, Valentino.
Or as we say down here...

Bloody legend, mate.

Tony.
Doc2.docx
0
 
Tony303Author Commented:
Bloody legend, mate.
0
 
ValentinoVBI ConsultantCommented:
Glad to have been of assistance, and indeed, some properties in SSRS are hard to find.  Sometimes it's interesting to explore the options in that properties window a little, I've achieved lots of stuff that way!

PS: your question has inspired me for my next article, thanks for that! :)

VV.
0
 
Tony303Author Commented:
Yeah, I agree it is a great article subject.

T
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.