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
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
Microsoft SQL ServerSSRSMicrosoft SQL Server 2008
Last Comment
Tony303
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
PS: your question has inspired me for my next article, thanks for that! :)
VV.
ASKER
Yeah, I agree it is a great article subject.
T
T
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