Need macro to update graphs

[DaniilK]

I have multiple graphs that read from rows varying in length from 2 to 60 columns long, depending on user input. I need help in creating a macro that readjusts the graphs to read from smaller/larger data set.

I created one that said: If user input = 1, then set graph to (A1:A1), If user input = 2, then (A1:B1), but this is really inefficient. Is there a better way? Thanks!

[Richard Buttrey]

Hi,

Have you tried using range names in your graphs, then in the macros, adjust the named ranges dependent on the user input, rather than changing the graph references?

HTH

[DaniilK]

Richard, Thanks for replying. Thats a good idea but I am still runing into a problem:

the code to reset the range name is something like this:

Please Login or Register  to view this content.

[/B]

Excel generates this weird reference to cells (above) which I can't replicate. How can I get around it?

In other words i need code that would say, if user input = 5, set name range to xxx.

[Richard Buttrey]

Hi,

Use code like the following to set your range name.

Please Login or Register  to view this content.

HTH

[jolivanes]

I get all my charts made with the help of the following:

http://www.andypope.info/charts.htm

http://www.tushar-mehta.com/excel/charts/

http://www.oaltd.co.uk/Excel/Default.htm

http://www.peltiertech.com/Excel/Cha...mmySeries.html

These are by no means the only ones available on the net.
It sounds like Tushar Mehta has charts on his site you can download that meet your criteria.

Good luck.

John

[DaniilK]

Richard,

Thanks for your help, but I am still getting stuck (last line of code below):

Please Login or Register  to view this content.

What am I doing wrong here? The last line of code doesn't work, and I've tried different things to fix it, and debugger still gives me a very confusing error message, something about "global object method failed".

[jolivanes]

Is the column reference right or is this a typo?

Please Login or Register  to view this content.

John

[VBA Noob]

DaniilK,

I've added the codes tags for you as per forum rules below. Next time you post please use the code tags to avoid being issued with an infraction

VBA Noob

[DaniilK]

I've actually gotten it to work. Thanks to all for the help!

[Richard Buttrey]

Hi,

What's that [B] doing there?

Rgds

[VBA Noob]

Richard,

Guess the OP knows how to use bold tags but not code tags.

I will tidy it up

VBA Noob

[jolivanes]

DaniilK
I am still learning so would it be possible to show me what you did to make it work?

Thanks and regards.

John