I'm trying to create a function where I can identify the chart I intend to populate on Sheet1. The chart will get its x-values and y-values based on a structured reference.
For example:
addTrend("Chart1","Sheet1",MyDataTable[MyXDataHeader],MyDataTable[MyYDataHeader])
I have been at this for hours and I cannot seem to find any available resources on how to
- handle structured references in a user defined function and
- get the desired data sources into the chart?