Hi there Does anyone know if there is a way to show a collected bar as one can with a pie chart? On a Pie chart you can collect items where the value is say <2% into one slice of the pie. I would like to do the same, but with a bar chart. Many Thanks Deb

Hi Debbie, According to your description, you would like to separate your data to two parts in chart, you can take use of the Group property to archive it, right-click the Category group item, select Category group properties click the fx button right adjacent to Group on drop down list, specify the expression like below: =Fields!percent.Value<0.02 Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.