I am having trouble formatting a chart. I have a simple table that
records the no of children attending certain groups we run which is
recorded against the date. The table has been constructed with filters
so that you can click on the names of the different groups and only
numbers for that group are displayed. I created a bar chart from the
table which much to my surprise changed with the filters on the table
this was great.

When not using the filters and looking at all the groups I decided to
colour code each group so that when looking at the bar chart one group
could be compared to the other. I did this by colouring each data point
seperately on the chart.

This worked fine until (and here is the problem I would like help
with.) I selected a filter again the colours applied to the data points
no longer remained with the same data points. i.e if I coloured an
activity yellow and selected a filter on the table for that group all
the chart should be yellow but it is not. I need to be able to keep the
same colours applied to the individual data points no matter what
filters I use

If this message is not clear perhaps I could send the spreadsheet to
anyone you can help to see the problem more clearly. My e-mail is
michael.smith(remove

Many thanks