Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Add series grouping to only one chart area

Unanswered Add series grouping to only one chart area

  • Wednesday, January 09, 2013 12:50 AM
     
     
    Sign In to Vote
    0

    Have gotten a lot of good info here, but first time asking a question.

    I have multiple charts which I would like to have aligned vertically on a report.  For 3 of the 4 of the charts, this is no issue as I have just added multiple chart areas to one chart and aligned.  x-axis on plot is time, and for simplicity sake, lets say vertical value on main plot is RunningSum of the amount produced at each time. 

    However, one chart I want needs to have a series grouping which is causing my issue.

    What I am trying to do is along the bottom of the amount produced chart, I am trying to show who was operating at the time.  I am doing this by using Count[operator] on each category group (time)which always evaluates to 1,  and series grouping by operator so each operator is displayed as a different color.

    I have each of the plots working correctly in different charts (One chart with 3 areas for ungrouped plots) and one chart (column or area works) for the plot grouped by operator.  I REALLY need these to be aligned vertically so it is easy to see who was working when.  

    Is there a reasonable way to add this "grouped" chart to the other chart areas?  Is there a workaround?  

    Thanks in advance.  MSDN doesn't seem to want to verify my account, so I will try to follow up with an image of what I am looking for.

      

     

All Replies

  • Thursday, January 10, 2013 6:31 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Bkrdr,

    From your description, you want to align vertically those charts so it is easy to see who was working when. This means that those charts have the same categories, right? In Reporting Services, we can use separate chart areas for data that share categories but use different scale for value. Multiple chart areas on a single chart feature is also useful if you are trying to compare data that has different scales of values. For more information about chart areas, please see using chart areas section in the link below.
    http://msdn.microsoft.com/en-us/library/dd239326.aspx

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Thursday, January 10, 2013 8:15 PM
     
     
    Sign In to Vote
    0

    Thanks very much for the response.

    What you are saying is very much what I am trying to do, however it is my understanding that adding a series grouping to one chart area will apply the grouping to all chart areas(within the same chart).  As I do not want to apply the series grouping to the other chart areas, this makes it very difficult.  

    If there were a different way to accomplish the operator plot in a without needing the series grouping, it would be great, but I am having a difficult time accomplishing what I want without the grouping.  

    FYI SSRS 2008 R2 (RB 3.0).  

    Here is an image of what I am trying to accomplish: Ideally, I would hide the x-axis on the upper plot and put it on the lower plot.  The plot would essentially be to say " operator 1 was there from the beginning until just before 11:00, and then operator 2 was there until the end.

    --Nevermind, despite doing everything possible to verify my account, I am still unable to attach images... 


    • Edited by BkRdr Thursday, January 10, 2013 8:16 PM
    •