Excel 2007 : Show Last 25 values in Chart

**jrs362** · 01-30-2011, 11:30 AM

I've got a chart with some dollar values that are all listed in Column I and get updated each time I add an entry to the sheet.

What I'd like to do is have my chart dynamically adjust to show only the last 25 values I've entered.

I've attempted this with the offset formula but I'm quite a bit confused by it and didn't have any luck.

Please Login or Register  to view this content.

Thanks

**DonkeyOte** · 01-30-2011, 11:36 AM

In terms of OFFSET

Please Login or Register  to view this content.

**DonkeyOte** · 01-30-2011, 11:41 AM

A non-volatile equivalent would be:

Please Login or Register  to view this content.

per the OFFSET it is assumed the numbers are always contiguous

**jrs362** · 01-30-2011, 01:47 PM

OK, I tried both of those and could not for the life of me figure out exactly where to put those formulas. I attempted to put them in as the chart's source data but I kept getting an invalid formula error.

I've attached a stripped down sample of my spreadsheet. Currently, I have the chart set to only use the first 50 rows available for data even though I only have 30 rows of actual data there. Since I have more than 25, the first 5 values (After the heading) in Column I should not be charted.

What am I missing when trying to do this?

**DonkeyOte** · 01-30-2011, 02:47 PM

I'm no Charting whizz I'm afraid but below should work:

Please Login or Register  to view this content.

Right click on your Chart, Select Data then select "Balance" and click Edit and set Series Values as:

Please Login or Register  to view this content.

I can't find any other way (other than Evaluate) to have the Dynamic Range persist but as mentioned I am no charting expert - plenty here are and are likely to have better alternatives.