>Hi
>I have a code that populate data in excel.
>Every thing is good but I have few small problems:
>3. My graph showing total from 1998 till 2005, But my uery will bring another line next year (2006) and another in the year after, how can I tell the graph to show all the years?
>
I would base the graph data on a named range instead of just rows/columns. Then if need be, adjust the named range definitions.