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.
