Re: Number of columns in Bar Chart

Home Forum Reporting Number of columns in Bar Chart Re: Number of columns in Bar Chart

#4914

Peanuts890
Participant

Thanks for pointing me in the right direction. I made multiple copies (duplicates) of my data source, one for each range of department names. Selected the department name (my X-axis)from the data source and applied a filter to this field using the sub-string function, eg. for departments starting A-D the filter was, sub-string(dept,0,1)<“E” and for departments in the range M-P, the filter was (sub-string(dept,0,1)>”L”)AND (substring(dept,0,1)<Q). This works great and does exactly what I wanted.

Thanks again.