Jun 11 2017 12:11 PM
Hello Everyone
I have data in a Excel Worksheet that I populate into another tab of the same worksheet to create a graph of the data. I have a large number of data points in the tab so I cut and paste each line one by one. Is there a way to automate this process so that it would act as a slide show in the chart tab?
Jun 12 2017 01:44 AM
Jun 12 2017 10:21 PM
Jun 13 2017 01:18 AM
If the only purpose of moving data from one tab to another is to build the graph on subset of data, why don't build it on full set and use any kind of filtering (e.g. slicers) to show proper graphs?
Jun 13 2017 09:42 AM
Jun 13 2017 09:43 AM
Jun 13 2017 01:11 PM
SolutionHello Everyone
With a little help from my son I figured out a solution. Utilizing the data tab and Data Validation tool. I named the cell and then I allow the List added the source column and created a drop down of that column.
Jun 13 2017 01:11 PM
SolutionHello Everyone
With a little help from my son I figured out a solution. Utilizing the data tab and Data Validation tool. I named the cell and then I allow the List added the source column and created a drop down of that column.