Solved

Excel Graph in SSRS report

Posted on 2013-12-12
5
453 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
[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 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

622 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