Link to home
Create AccountLog in
Avatar of Tony303
Tony303Flag for New Zealand

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Tony303

ASKER

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
Avatar of Tony303

ASKER

Bloody legend, mate.
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.
Avatar of Tony303

ASKER

Yeah, I agree it is a great article subject.

T