yogi_In Google Old Sheets Create A Bar Chart Upto Last Populated Row Only (dynamic range updating)

                                     Google Spreadsheet   Post  #1688
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-05-2014
post by synergy.ron: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/qxrtyr8uiJ0)
Sheets Old format Charts dynamic range seems to be not possible?
Since I can not create a sheets template using the 'New' format, my chart is in the 'old' format.  

I can not use the 'New' format because I need to post a template.

https://docs.google.com/spreadsheet/ccc?key=0ApSC-MU1fbP6dE15M0JLTHdobG1sU19MTTZoa2VmX1E&usp=sharing

I have a pivot table with 3 columns:  

     A                  B                   C

7)   Account        Actual              Budget

There are 35 Account rows

The range for my bar chart is A7:C42 .  

This works.  However, my users may have more or fewer than 35 rows.  

Easy right?  Just designate the range as A7:C .  Or use A7:C95. 

 Nope.  This 'squishes' all the Accounts on the Y axis together into an unreadable mess or Sheets just refuses to recognize the range.  

And Charts does not seem to accept range names or formulas.

Since Google, for 7 months,  has failed to address the consequences of their 'NEW' format and it's incompatibility with template creations I hope a more experienced user than myself knows how to get around the problem.

Thanks for your thoughts.

---------------------------------------------------------------------------------------------