I'm trying to create a chart that allows for several ranges of data. My problem is that the Category X axis value appears to require manual input (rather than a cell link). Is there any way (in VBA or Excel) to fix this? Many thanks!