Solved

Excel Graph in SSRS report

Posted on 2013-12-12
5
436 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 500 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Embed SSRS report in body of SMTP Email 5 264
Data source in SSRS 2 58
SSRS Problems 9 85
SSRS Deployment problem 5 67
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …

828 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