I have a chart created from a pivot table that displays all the data in one group. Whenever I filter it to just one data set the format of the chart is lost. In conclusion I cannot format a chart throughout an entire set of data from a pivot table when I filter to see one data set, multiple data sets, or all data. Any ideas?