Automated Reporting

[TIG_Slayer]

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.

[ranman256]

Orange you glad I didnt say banana?

Ok, yes the data exports to the same page even w data in it.
So you must either:
delete the existing xl file, and use a template that has the graphs in it for the new sheet.
or
take control of xl, clear the data in the sheet, THEN export the data.

[TIG_Slayer]

Orange you glad I didnt say banana?

Ok, yes the data exports to the same page even w data in it.
So you must either:
delete the existing xl file, and use a template that has the graphs in it for the new sheet.
or
take control of xl, clear the data in the sheet, THEN export the data.

Very punny haha.
That helps a little bit, but I am no pro when it comes to excel or access. Essentially I want to export the crosstab using a macro to excel, and then from that exported excel file, link the values in that crosstab to another excel workbook that has seperate sheets and graphs for the items. The complication is when the new items are appended after all is said and done, it will cause the cells to be referenced incorrectly. I know i could probably do this without it being in ascending order and it wouldn't be an issue, but I would like the crosstab to be in ascending order. Hopefully this makes sense.