?
Solved

Excel Graph in SSRS report

Posted on 2013-12-12
5
Medium Priority
?
492 Views
Last Modified: 2013-12-21
Hi All,

I want to achieve the excel graph in SSRS, I tried to do so , but unable to achieve.

Please find the attached screen-shot of the same and let me know if any clarification required.
Screen.jpg
0
Comment
Question by:prashant04
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Tony303
ID: 39715216
Yes this is possible,
You can create a stacked bar chart very similar to your excel one.

How experienced in SSRS are you.


Here is an article.


http://social.msdn.microsoft.com/Forums/sqlserver/en-US/33210df6-15df-4b00-a7f2-e6f12eb1d649/ssrs-stacked-column-chart-with-two-value-series?forum=sqlreportingservices
0
 
LVL 12

Expert Comment

by:Tony303
ID: 39715233
0
 

Author Comment

by:prashant04
ID: 39715780
I Tried the same solution, however its work partially, want two stacks like Actuals and baselines as per the excel. as per last solution I am able to achieve only for actuals, I am unable to add another stack on the same chart.

Please suggest.
0
 
LVL 12

Accepted Solution

by:
Tony303 earned 2000 total points
ID: 39717816
Hi,
I think you need to make a Category Group in the chart and have the field that contains the words Actual and Forecast.

That should give you the x axis with 2 stacked bars.

Do a google image search on ssrs stacked bar, you will see some examples I'm sure.

Can you post the graph and the chart data expanded on the right just to see what you have.

T
0
 

Author Comment

by:prashant04
ID: 39733678
I tried and its working, Thanks.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

578 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