VBA Error when running macro

**willist** · 07-24-2012, 12:52 PM

Greetings,

Could someone please tell me why I am getting an error. I used the "Record Macro" to capture a few things and then I added some of my own stuff. The macro fails almost immediately. Why is this?

Also, all the columns in the chart are dynamic ranges.

here is the macro code. it just starts the creation of a graph.

Please Login or Register  to view this content.

Here are pictures of the error. I have also included the excel file.
error.JPG error2.JPG

Thanks,
Willis

**vandan_tanna** · 07-24-2012, 01:47 PM

Two things come to mind.
1. I do not think you need two equal signs for the values.
2. Make sure the named range Power exists in your file and it has data.

If that doesn't help, upload your file so we can help you futher

**willist** · 07-24-2012, 03:54 PM

Okay that fixed it. For some reason when I was recording the macro erroneous information was added.

I have one more problem and then I think everything should be fixed.

Whenever I generate the graph using the macro, a bunch of "ghost" series appear that I didn't create and mess up my graph.

Any ideas? I have attached the code and picture.

Please Login or Register  to view this content.

error3.jpg

Thanks in advance

**JosephP** · 07-24-2012, 03:57 PM

if the current cell has data in it then the current region will be used as the source data for the chart when it is created. if you select an empty cell first you shouldn't see the issue.

**willist** · 07-24-2012, 04:26 PM

Oh that is fantastic. I just added a line that selects a empty cell before the chart gets created in my macro. Thanks!

Now I have one last question. Is there an easy way to have the user input a specific range of data that he wants to plot. Say there are 500 entries. Running the macro will generate a graph that displays the entire range. I then want the user to be able to say "display from 200 to 300", and then the macro will create a zoomed graph on a seperate page of that range.

Thanks for all the help so far.

**vandan_tanna** · 07-24-2012, 04:35 PM

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

this is Stephen Bullen's page

Look for charting example and file called funchart7.zip

This demonstrates how to used defined names and scroll / zoom bar. Cool stuff.