Hello All,
I created a chart that I visually like but I am trying to have the chart adjust based on a start date that I entered from another field. This is the yellow cell I have highlighted in my sample workbook. In addition, I would like to avoid having blank rows print if a resource task doesn't fall within the start date that I entered. Please see sample excel.
Any assistance is greatly appreciated!
Thank you
Michele
Hi Michele,
There's currently no way to link the minimum start date on the horizontal axis in your chart to a cell and because of the way the chart is built (with the start date bar hidden) you cannot use dynamic named ranges for your chart data.
You'd have to write some VBA code to automatically update the minimum start date when the value in cell J2 changes. If you get stuck with this, please post your question in our VBA forum.
Mynda