Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS Bar Chart 2 Values on 1 Axis

Posted on 2014-01-08
5
Medium Priority
?
2,266 Views
Last Modified: 2014-01-09
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
0
Comment
Question by:Tony303
  • 3
  • 2
5 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 39767263
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
 
LVL 12

Author Comment

by:Tony303
ID: 39769178
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
 
LVL 12

Author Closing Comment

by:Tony303
ID: 39769195
Bloody legend, mate.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39769230
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
 
LVL 12

Author Comment

by:Tony303
ID: 39769357
Yeah, I agree it is a great article subject.

T
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question