Hi Kaushik03!
Thanks so much, I am such a newbie at all this!
I've uploaded it to Skydrive, link is here: http://sdrv.ms/PgzcX4
I want the chart to be selective by Group.
I have 4 areas of information to display across 3 different types of chart. Someone suggested using data validation and lookup to change the data displayed in the charts according to user preference. Is this possible and how do I do this?
Ideally I want to create a front worksheet with links to 4 different worksheets (displaying the same types of data but for different areas) but I want to keep these worksheets hidden. Hyperlinking doesn't work to hidden worksheets, is there anything else I can do?
I am creating a dynamic pivot chart in excel 2003. However every time I update the chart, the formatting reverts back to the original. I know this is an issue in 2003 and I need to do something with macros in order to preserve the formatting. However I am a complete newbie when it comes to...