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 |
|
theeBadger
Starting Member
3 Posts |
 Posted - 2010-12-30 : 05:49:05
|
| I'm using SSRS 2005 to create a bar chart - where the bars are horizontal and there is a bar for each item on my chart.There are a lot of items to display and some of the item labels didn't display. So I made the height of chart bigger.This works for my current dataset. However it will be a problem if the number of items in my dataset increases.It is also a problem when the data is filtered and less items are displayed (in this case there is an unnecessarily large chart with thick bars)My research has shown that there is a dynamic size property in SSRS 2008. However I can't use that for this project and was hoping that someone could come up with an alternative solution. |
|
|
pzajkowski
Starting Member
2 Posts |
Posted - 2011-01-06 : 09:20:33
|
| A good way to ensure that horizontal bar charts look uniform is to embed a chart in a table row (This technique is often referred to as an inline bar chart). Two primary techniques exists: 1) actually embed a chart object in a table row, or 2) embed an image in a table row that can be resized using a calculation that dynamically changes the padding around the image.Check out the following webpages on these two techniques. They are quite useful, and will tolerate any number of items that need to be charted:Embedding a chart object in a table:http://msdn.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic4 (Scroll down to Table Inline Charts)http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx#AvoidSingleCharthttp://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx#maxminvaluesEmbedding an image in a table to simulate a bar chart:http://blogs.msdn.com/b/bobmeyers/archive/2005/10/15/481342.aspxhttp://www.bidn.com/blogs/TomLannen/bidn-blog/1106/creating-an-inline-bar-chart-databar-for-ssrs-2005http://spacefold.com/lisa/post/2008/06/22/Walkthrough-A-bar-chart-trick-examined-and-a-charting-alternative-offered.aspxAs a side note, my only complaint about the examples provided in the links above is that they all tend to using "gradient" fills or 3D rounding in an effort to make the bars on a chart more "interesting". Adding glitz to a chart is unnecessary and distracting. Stephen Few at http://www.perceptualedge.com provides excellent information regarding proper techniques for displaying charts and graphs. His books are brilliant. |
 |
|
|
theeBadger
Starting Member
3 Posts |
Posted - 2011-01-13 : 09:51:37
|
| Thanks for the response. I will try these methods out. |
|
|
|
|
|
|
Bar Chart Size Problem