• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 498
  • Last Modified:

Excel Graph in SSRS report

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
prashant04
Asked:
prashant04
  • 3
  • 2
1 Solution
 
Tony303Commented:
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
 
Tony303Commented:
0
 
prashant04Author Commented:
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
 
Tony303Commented:
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
 
prashant04Author Commented:
I tried and its working, Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now