Dynamic chart ranges

[RichardMGreen]

Hi all

I'm trying to sort out a chart that will have between 1 and 28 items on the X-axis.
At the moment, I'm plotting all 28 items (eve if they're blank) and the graphs look a mess.

I've done a bit of research into this, but I didn't understand any of it.

My formulas for producing the graphing data go from J28 to J55 on Sheet "Graphs".

Can someone please give me some idiot-proof instructions on sorting this graph out so it only shows displayed information for 2 Y-Axes and the X-Axis so the graphs automatically sorts itself out?

 

[Steve=True]

There are a couple of ways you can do this.

You can use offset function combined with Count - Here are instructions and a video tutorial:
http://www.exceldashboardtemplates.com/?p=688


You can put your data in a table if you are using Excel 2007 or 2010 and it will be treated as dynamic as you add data:
http://www.exceldashboardtemplates.com/?p=516

A Pivot Table may also work for you.

Steve=True