Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Bar and Line chart Expand / Collapse
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: Monday, December 29, 2014 11:32 PM
Points: 8, Visits: 28
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


Group: General Forum Members
Last Login: Yesterday @ 9:59 PM
Points: 2,134, Visits: 12,262
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