MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Using Excel VBA to chart a moving annual total

  Asked By: Keana    Date: Feb 07    Category: MS Office    Views: 2501

I'm trying to automate updating a number of dynamic charts in an
excel spreadsheet. I've created a userform which prompts the user to
input 4 values (including a date), and then inputs the data into a new
line on a sheet. What I now need to do is write code which gets each
chart to include the new line of data, and to exclude the first line.
For example, the charts currently look at the range A4:A16, but when
the new data is added to row 17 I want the charts to plot A5:A17 (and
so on each month).

I've tried using the OFFSET and SERIES functions, but this only seems
to let me add a new line in to the chart source data while retaining
all the rest.

Please help! I hope I've explained this problem clearly.



1 Answer Found

Answer #1    Answered By: Janelle Evans     Answered On: Feb 07

OK, managed to find a way of producing 'dynamic' charts. For those who
would like to know, have a look here:

Didn't find what you were looking for? Find more on Using Excel VBA to chart a moving annual total Or get search suggestion and latest updates.