Solved

SSRS Bar Chart 2 Values on 1 Axis

Posted on 2014-01-08
5
2,064 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 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Bloody legend, mate.
0
 
LVL 37

Expert Comment

by:ValentinoV
Comment Utility
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
Comment Utility
Yeah, I agree it is a great article subject.

T
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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 insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now