Trying to automate a simple chart by applying a NAME range to the data range. Works, but converts the NAME range to cell references... anyone know or if possible to keep a data range in a chart as a formula or range name.