Solved

SSRS Bar Chart 2 Values on 1 Axis

Posted on 2014-01-08
5
2,195 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

617 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