Macro to create graph for each row in table

Hi everyone,

I'm trying to speed up the process of creating 83 graphs from a table of data.

I have attached the data to the post along with a sample of what the graph needs to look like.

Is there a marco i could use to do this?

Thank you in advance!

Hi

How about not using macros and just using a 'clicker' to select/view charts???

..see attached file.

Clicking the 'clicker' updates cell [Z1] with the current clicker value.
We can then use simple INDEX formulas to 'fetch' corresponding row data into range [AB2:AM2]
..then the source data for the chart is just [AA1:AM2]

We could do more with macros of course, like having a 'search' box where you type the name you want etc etc etc.

Anyway, this is just a start..

zeddy

Hi

..and if you don't like my clicker in the file I posted, just enter the row number of the one you want to see charted in cell [Z1]
..for example, put 22 in cell [Z1] and you get chart for row22 i.e. DW SOLICITORS (NORTHAMPTON)

zeddy

Hi popipipo

Your solution is better but I would like to say insofar as manifestations of functional deficiencies are agreed by any and all concerned parties to be imperceivable, and are so stipulated, it is incumbent upon said heretofore mentioned parties to exercise the deferment of otherwise pertinent maintenance procedures and I thank you for your research, diligence, and hard work.

..you did notice it looked like lawyer-stuff, right????

zeddy