ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel chart that updates to use last 13 values in a row (https://www.excelbanter.com/charts-charting-excel/450513-excel-chart-updates-use-last-13-values-row.html)

Wellsie

Excel chart that updates to use last 13 values in a row
 
Hi,

Does anyone know how I can create a chart that will use the last 13 data points in a row please?

Thank you

Claus Busch

Excel chart that updates to use last 13 values in a row
 
Hi,

Am Thu, 11 Dec 2014 22:18:27 +0000 schrieb Wellsie:

Does anyone know how I can create a chart that will use the last 13 data
points in a row please?


create a dynamic range name for the last 13 rows and use that name for
the chart.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com