Hi, I'm trying to create line graphs that show where a current value is along a range. I've decided to go with XY Scatter and add error bars with caps. Data and images below, running into the following problems:
- I created the charts via VBA and anchored them to the corners of the cells I...