sql server - Reporting Services Chart - Hard Coded Series -


I am developing an SSRS 2008 report that includes several simple charts on the X axis, I have 12 months- From January 2009 to December 2009 Increases from 10 to 10 on Y is an integer value of 0 to 100. I am plotting a number of problems per month. Therefore, January 10, 30, etc. may be worth the price etc.

I have a horizontal line / series which is constant and shows the annual average for 2008. So, say average 30 points per month in 2008, I would like for the line shown in my chart. Actually, I want to draw a straight line in the chart for that value ... I can see how much more complicated The series is to be added, but it seems that simple work is getting better for me.

How can this be accomplished? Thanks in advance, Jason

[Update] To add some more details, I'm already pulling averages for each line in my dataset and it's in my series However, instead of plotting a line, this approach plots individual points for each month. Although it is close to what I want, I must be involved in points to talk about. Chart error bar (range) diversity

Can you use a column / line hybrid chart Are you If so, add a static or dynamic target value to the chart:

Design a chart On the Data tab in the Character Properties dialog box, add a new data value (for example, Goal). Set target value (see example 9 in the link on the link, it uses continuous target value of 100000 in all categories, but you can do it dynamically). Be sure to use the expression starting with = (equals) Otherwise, the value is not explained as a numeric value.

See example on the MS Charts page


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -