Confused_xls
New Member
- Joined
- Oct 11, 2006
- Messages
- 2
Hi All,
I am having a issue with using Auto Filter and making charts. When I create the charts from my data set and then set a Auto Filter on it, whenever I filter the dataset my charts get mixed up as the Data Source is set for a fixed cell range. How can I create my charts so that the Auto Filter will not mix them up when I sort my results?
Thanks for any and all help.
I am having a issue with using Auto Filter and making charts. When I create the charts from my data set and then set a Auto Filter on it, whenever I filter the dataset my charts get mixed up as the Data Source is set for a fixed cell range. How can I create my charts so that the Auto Filter will not mix them up when I sort my results?
Thanks for any and all help.