Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bar and Line chart Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 12:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 30, 2014 10:48 PM
Points: 3, Visits: 15
I have one ssrs report where on the x-axis we have country with state as a bar chart and on y-axis we have population for every state, but we want a line chart also on top of bar chart,but that line chart should come for individual country(means it will cover only the speicific states of the country). for other country, the line chart start from begining. It should not like from first country to last country(in continuation). it should break for individual country and it should cover only the states of one country. Pl advice.
Post #1554630
Posted Friday, March 28, 2014 9:34 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 709, Visits: 4,520
I think I understand what you're doing. It sounds like you're trying to use some kind of grouping on states on the X axis... but the design sounds really odd. It would make sense if the X-axis was a time series or something like that, but as discrete values (Country,State) {(x,1),(x,2),(x,3),(y,1),(y,2)...}.

Makes a LOT more sense as a bar chart. My guess is that you might be able to use a trendline or something similar, but since the groups are discrete, it doesn't really make sense.
Post #1556186
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse