Chart

[fraser5002]

Can anyone explain how i would go about creating a chart using every second row for the input data

I tried to hide every second row and do it that way but i also have hidden cols and excel is moaning that the data series is to complex ????? im assuming its because i have hidden rows too as it worked fine with just hidden cols

[georgiboy]

The truth is i dont know the correct way to achieve this but here is an idea. You could use some code to take every other row from your data sheet and place it into a seperate sheet, then create the chart from the new sheet.

Hope this sparks an idea for you.