EE-DynamicDataPlot.xlsx

<div>
Very elegant. &nbsp; I had come up with a method where I specified a row to contain the data that was plotted and my pulldown copied the target data to the &quot;plotting row&quot;, each time I wanted to plot a different data set. &nbsp; Yours does the same but I will learn more from it. &nbsp; &nbsp;Thanks for all the time it took to perfect this.
</div>


Very elegant.   I had come up with a method where I specified a row to contain the data that was plotted and my pulldown copied the target data to the "plotting row", each time I wanted to plot a different data set.   Yours does the same but I will learn more from it.    Thanks for all the time it took to perfect this.

<div>
You're welcome. &nbsp;I had actually considered your method (using a set of VLOOKUPS) but realized I could use a dynamic range name to achieve the same without needing an extra, dedicated &quot;plotting row.&quot;<br />
<br />
-Glenn
</div>


You're welcome.  I had actually considered your method (using a set of VLOOKUPS) but realized I could use a dynamic range name to achieve the same without needing an extra, dedicated "plotting row."

-Glenn

<div>
<div class="content wysiwyg-content">
I have time series data to graph. &nbsp; There are say 20 rows of data, one for each item, and a row containing a date series, which is common to all the data. &nbsp; I want to be able to specify which row to plot and have the plot show that row. &nbsp;I do not want a different graph for each row or one graph for all the rows. &nbsp; Is there a way to do this?
</div>
</div>


I have time series data to graph.   There are say 20 rows of data, one for each item, and a row containing a date series, which is common to all the data.   I want to be able to specify which row to plot and have the plot show that row.  I do not want a different graph for each row or one graph for all the rows.   Is there a way to do this?

In excel graphics is there a way to softcode the location of the data (and the legend) so one graph format can be used for several data sets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.