locked
Creating dynamic charts with macro RRS feed

  • Question

  • Hej everyone

    Im having trouble with creating variating charts through VBA. I hope someone can give me a hand.

    I have an excel sheet where i have a number of components, with corresponding "result entry dates" and "results". I have made a macro which isolates the data according too what component i want to observe. The main idea is, that you can pick a component, which then generates a new sheet. In the sheet i have the isolated data, which i manipulate so i have the desired data for a chart. I then need to have a macro make a chart corresponding to the specific data, and data labels. 

    The problem is, how do i make the chart macro independent of the sheet, and the data range, so it plots the correct chart for the corresponding component sheets?

    I have tried to define the data range as a dim, but without success...

    Any ideas?

    Wednesday, November 23, 2011 3:10 PM