I am working on a bar chart where most of my Left Y-axis data points fall between 70% and 100% so I set my Left Y-axis to have a fixed minimum of .7 and a fixed maximum of 1 (this makes a prettier graph without data point values all crunched up together at the top with it going all the way down to 0. But... there are times when a user makes a selection for a small population of students and the value for those retained is 0%. Because I have that minimum set to .7, the data point for that year for that selection of population does not appear on the bar graph because it is below .7 so ... is there a way to have the Left y-axis self adjust to include all data points but make a more spread out display with smaller min and max for when the data points fall within that range? Thanks, Rhonda   ... View more

I am trying to have a crosstabs chart with columns that are driven by filters. For example, a user may check a gender filter (male or female), a race/ethnicity filter (non-underrepresented or underrepresented), a race/ethnicity groups (African American, Asian, White, etc). I would like for my crosstabs to have the columns with measures (numbers of retained students, etc), but with rows of cohort year, and then rows for fields driven by filter selection - so gender, race/ethnicity, and/or race/ethnicity groups ONLY if those fields are checked in the filters above. Is there a way to make this happen? Thanks, Rhonda     ... View more