|
|
You're in the
sql server reporting services
group:Stacked Bar with Median Line
sql server reporting services:
greater than 25% and less than 75%. I do this by setting the color of the first and last bars (in the stack) equivilent to the background color. Another requirement is to display a vertical line showing both the average and the median points. I was attempting to do this using the gridlines in combination with the Y axis labels. Is there a way to add a formula to the gridline display (i.e. only display gridline when gridline = Median)? Any other ideas on how I might accomplish this? I was going to try to overlay another chart with just a verical line, but I was not able to create this. Any suggestions would be appreciated. Thanks,
You cannot add a formula for the gridlines. However, you can try this:
* add another arbitrary data value to the chart * open the chart properties dialog * edit the data value you just added * replace the value expression with an expression that calculates the median (e.g. =50 , if the median has a constant value of 50%) * go to the Appearance tab in the same dialog * check "Plot data as line" Note: this only works for a stacked column chart (which I think you are actually using based on your description with the y-axis labels) and not for a stacked bar chart. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "MMcGoff" <MMcGoff@discussions.microsoft.com> wrote in message news:490D1B01-9010-4F94-BE1E-F09067DECA26@microsoft.com... >I am attempting to create a stacked bar chart that shows only data points > greater than 25% and less than 75%. I do this by setting the color of the > first and last bars (in the stack) equivilent to the background color. > > Another requirement is to display a vertical line showing both the average > and the median points. I was attempting to do this using the gridlines in > combination with the Y axis labels. Is there a way to add a formula to > the > gridline display (i.e. only display gridline when gridline = Median)? > > Any other ideas on how I might accomplish this? I was going to try to > overlay another chart with just a verical line, but I was not able to > create > this. > > Any suggestions would be appreciated. > > Thanks, > > Megan
Actually, I am using a stacked bar chart (I was incorrect in my axis - it is
the x-axis labels I wanted to change). In the end I am looking for a horizontal bar with the beginning and end points labeled and then a vertical line at the median point. I can get this all working with a stacked column chart - is there a way to "rotate" the chart? I can't seem to find any way to create a vertical line - is that possible? I was going to attempt to overlay charts, but without a vertical line I can't. Thanks, Megan [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> You cannot add a formula for the gridlines. However, you can try this: > * add another arbitrary data value to the chart > * open the chart properties dialog > * edit the data value you just added > * replace the value expression with an expression that calculates the median > (e.g. =50 , if the median has a constant value of 50%) > * go to the Appearance tab in the same dialog > * check "Plot data as line" > > Note: this only works for a stacked column chart (which I think you are > actually using based on your description with the y-axis labels) and not for > a stacked bar chart. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "MMcGoff" <MMcGoff@discussions.microsoft.com> wrote in message > news:490D1B01-9010-4F94-BE1E-F09067DECA26@microsoft.com... > >I am attempting to create a stacked bar chart that shows only data points > > greater than 25% and less than 75%. I do this by setting the color of the > > first and last bars (in the stack) equivilent to the background color. > > > > Another requirement is to display a vertical line showing both the average > > and the median points. I was attempting to do this using the gridlines in > > combination with the Y axis labels. Is there a way to add a formula to > > the > > gridline display (i.e. only display gridline when gridline = Median)? > > > > Any other ideas on how I might accomplish this? I was going to try to > > overlay another chart with just a verical line, but I was not able to > > create > > this. > > > > Any suggestions would be appreciated. > > > > Thanks, > > > > Megan > >
Hi Robert,
Thanks for the help. Actually, I am working with a stacked bar chart (I incorrectly labeled my axis - it was the x-axis that I wanted to change). In the end what I am looking for is a horizontal bar that shows the beginning and ending datapoints with a vertical line representing the median running through the bar. I can get this working using a stacked column and a horizontal median line. Is there any way to "rotate" a chart? I can't seem to figure out how to create a vertical line - is this possible? I was thinking about overlaying a couple of charts, but without a vertical line I am at a loss. I tried using the line from the toolbox, but I can't dynamically control its location - can I? Thanks for the help, Megan [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> You cannot add a formula for the gridlines. However, you can try this: > * add another arbitrary data value to the chart > * open the chart properties dialog > * edit the data value you just added > * replace the value expression with an expression that calculates the median > (e.g. =50 , if the median has a constant value of 50%) > * go to the Appearance tab in the same dialog > * check "Plot data as line" > > Note: this only works for a stacked column chart (which I think you are > actually using based on your description with the y-axis labels) and not for > a stacked bar chart. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "MMcGoff" <MMcGoff@discussions.microsoft.com> wrote in message > news:490D1B01-9010-4F94-BE1E-F09067DECA26@microsoft.com... > >I am attempting to create a stacked bar chart that shows only data points > > greater than 25% and less than 75%. I do this by setting the color of the > > first and last bars (in the stack) equivilent to the background color. > > > > Another requirement is to display a vertical line showing both the average > > and the median points. I was attempting to do this using the gridlines in > > combination with the Y axis labels. Is there a way to add a formula to > > the > > gridline display (i.e. only display gridline when gridline = Median)? > > > > Any other ideas on how I might accomplish this? I was going to try to > > overlay another chart with just a verical line, but I was not able to > > create > > this. > > > > Any suggestions would be appreciated. > > > > Thanks, > > > > Megan > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |