Auto creating a chart using macros.

[chiefcheevs]

Hi,

I am new to this forum.

Basically I have a set of data that consists of country names down the first column and then, along the top row, years, from 1950 to 2012. In the cells between, there are numbers corresponding to the number of traffic accidents in each country in a certain year.

I want to create a line chart for each country with the year along the x-axis and the accident rate along the y-axis, showing the long term trend within that country.

My problem is that there are around 250 different countries for which I want 250 different graphs. This will clearly take an extremely long time to complete manually. I have searched for ways to do this in an easy manner but have not found a solution.

I was wondering if this is something that required a macro as I have never used one before. If there is an easy solution I am missing please let me know!

Thanks.

[PeteABC123]

Highlight your data first.
Then try messing with ALT+F1 or F11.