I have a rather complex Graphic that measures a "gap" between two points/dates, that Teylyn originally built out for me and I have a complex macro that generates a Interval/Frequency table that Martin Liss and Fanpages built. I'm now trying to combine the two.
First, the Interval/Frequency table is generated by selecting a Start Date, a number of Intervals, an Interval Metric and a Frequency Metric. From that, a table including an X1, Y1 and Y2 data points, is created (included in Range Name). X1 is simple since it is actually Date/Time. The Y1 and Y2 data is manually entered next based on the number of cells that get created for Y1/Y2.
What I need to have happen, is to link the data table (X1, Y1, Y2) into the original model that Teylyn created. By using the Range Names that are created from the Macro, I'm hoping to make the Graphic Dynamic so that as the cells expand or reduce given a particular scenario (from the Macro), the graphic will present correctly.
Thank you very much...... in advance.