Forum

Notifications
Clear all

Chart - Dynamic Start Date and Blank Rows

2 Posts
2 Users
0 Reactions
64 Views
(@mmemon)
Posts: 11
Eminent Member
Topic starter
 

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

 
Posted : 25/10/2022 1:57 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 25/10/2022 6:42 pm
Share: