Hi!
the situation:
i wrote a code that creates new pivot table whenever user clicks the correct button. I would like to modify some properties so the pivot chart would look nice (changing chart type for 1 of the series and keeping rest untouched). Unfortunately, whenever i do some changes, they disappear after the user takes any action. I tried the following to solve the problem:
1. defaulting chart type for the desired series, unfortunately it's the solution i would call "all or none". I can't change one of the series and keep other untouched at the same time.
2. creating a code that is realized whenever specific action (like clicking) is performed on the chart, the problem is that the name of the sheet changes all the time (the pivot table is recreated frequently). I cant write a code for a chart that does not exist (but will be created in the future).
3. creating a simple macro that do everything i want, it unfortunately needs user to activate it manualy all the time
question:
i think that the solution number 2 is the correct one, what should i do to make it work? how can i write a code for an event if the chart will be created later?
i use excel 2000
Bookmarks