Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
supriyorana
Starting Member
1 Post |
 Posted - 2014-02-03 : 08:05:39
|
| Consider the following input data: Currency performance weight EUR 0.01700 -9.4% GBP 0.00314 -8.7% JPY 0.04000 -16.3% CHF 0.03618 -17.6% AUD 0.21959 36.0% NZD 0.07490 15.0% CAD -0.01475 -3.8% NOK -0.00944 9.2% SEK -0.00173 10.3% Split the currencies into four different quadrants on the basis of the sign of the performance and the sign of the weight. (Positive weights on the rights, positive performance at the top.) Within each quadrant, sort from the largest to smallest weight (in absolute value). Like such: Quadrant IV 0.096320629 -0.1761072 Quadrant I 0.294495321 0.3604932 CHF 0.036178973 -0.1761072 AUD 0.219593499 0.3604932 JPY 0.04 -0.163392 NZD 0.074901822 0.1502532 EUR 0.017 -0.0937068 GBP 0.003141656 -0.0873612 Quadrant III -0.014748993 -0.0380868 Quadrant II -0.011171986 0.1034532 CAD -0.01474899 -0.0380868 SEK -0.00173335 0.1034532 NOK -0.00943864 0.0916932 Within each quadrant, draw a box of size |weight| x |performance| and stack then on top of each other. (The largest weight goes closest to the origin.) We can make quadrant I&III have the same colours and quadrant IV&II have the same colours. (For instance, blue and grey.)Would such a graph be possible in SSRS 2008? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-03 : 13:41:52
|
| look for stacked bar chart type in SSRS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSRS Chart 2008