How do I create a dynamic graph which follows a data range horizontally?

[rossmolden22]

So I figured out how to create a dynamic range going vertically from a guide online.

However, my data runs horizontally like so:

B1 C1 D1 E1
A1: Date Jan Feb Mar Apr
A2: Value A 50 41 6 73
A3: Value B 49 35 14 46

So I would like my graph to automatiically select the last 6 months, even if it has 12 months worth of data entered. Ideally, I want to enter say "6" or "3" into a cell in order to define the amount of months I want in the chart.

Can someone please help me with instructions on the formnulas for the "Define Name" process and setting the values in the graph wizard?

I would be eternally grateful to anyone that can help!

Thanks
Ross

 

[Robert Mika]

Hi and welcome to the forum
Look here
http://www.youtube.com/watch?v=7le-m8YRP6M

Althought this is verticaly you can adjust the OFFSET function to your needs.

In your case it maybe like this:
In B5:
=OFFSET($B$2,0,0,1,A5)

where A5 is the cell with your number