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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Tony303Author Commented:
Bloody legend, mate.
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.
Tony303Author Commented:
Yeah, I agree it is a great article subject.

T
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.