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 |
|
abarrett86
Starting Member
2 Posts |
 Posted - 2012-08-08 : 10:28:05
|
| I am having trouble with a particular us of Stacked Column carts in SSRS in SQL 2008 R1.We are charting data offloaded from a hardware system. The system has several modes it can be in. What I'd like to do is take the last reported 24 hour period and use a stacked column chart to show what modes the system was in over that 24 hours (each mode would have a specific color) and when it changed.For each change I have the following data points:modestart time (when switched to this mode)end time (when switched from this mode)duration (end time - start time)Any suggestions greatly appreciated.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-08 : 10:36:24
|
| seehttp://msdn.microsoft.com/en-us/library/aa964128(v=sql.90).aspxit has a section on stacked chart------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
abarrett86
Starting Member
2 Posts |
Posted - 2012-08-08 : 10:50:31
|
| I didn't see anything in that article about stacked charts. I search for 'stack' on the page and get a single hit in the text about pie charts. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-08 : 10:52:46
|
quote:
Originally posted by abarrett86
I didn't see anything in that article about stacked charts. I search for 'stack' on the page and get a single hit in the text about pie charts.
see the example charts given, it has stacked column example------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Dynamic stacked column