Forum Discussion
Axis Alignment
The key to this might be the fact that the chart calculation engine does not require range references; it will also accept named arrays. I would need to remind myself whether 'Tab 1'!Series1 is a legal name for a chart series or whether something else needs to be dreamt up. The presentation of the data restructuring will also appear rather different in 365 and legacy Excel. Something else that I have never tried, is to enter a 2D array rather than individual series; it may work but I wouldn't be too hopeful there.
The key to this might be the fact that the chart calculation engine does not require range references; it will also accept named arrays. I would need to remind myself whether 'Tab 1'!Series1 is a legal name for a chart series or whether something else needs to be dreamt up. The presentation of the data restructuring will also appear rather different in 365 and legacy Excel. Something else that I have never tried, is to enter a 2D array rather than individual series; it may work but I wouldn't be too hopeful there.
@https://www.businessstudynotes.com/finance/project-management/slack-time-formula-calculation/
Yes Really appreciate it.
- Thanks Peter for the response, I've since altered the approach to avoid creating a lengthily process. I initially wasn't sure if there was a function within excel which I missed and could support.
