Hello, I am currently working on creating an automated report using access. I have a query that creates a crosstab, and then exports it to excel. My problem is that new items will be appended to the report and will cause some issues when it comes to graphing them. How can I go about appending new items, but having the previous cells stay with the same graph they were referenced to before? Sorry if this sounds very confusing, but I am trying to explain the best I can.
Here's a simple example:
Apple
Banana
Orange
If you were to append grape, it would now be:
Apple
Banana
Grape
Orange
So now the cells that were used before to graph the sales of Orange would be incorrect, and would be graphing grape instead.
As said earlier, any help is appreciated, and sorry if it sounds confusing.