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 want, but lines don't appear uniform length and position within the graph (e.g. 1mo for "a" vs 1mo for "b")
- The values don't seem to be appropriately positioned relative to the min/max values (e.g. the 1 wk graph for "a" has a min of 105, a max of 111 and current of 105 - i'd expect the data pt to be all the way to the left)
- I'd like to add data labels for the min/max values but cant seem to find that option in the Error Bar Options
I'm not married to this graph type so if there's a better option (like a Sparkline?) that will give me the desired behavior, I'm totally open to it. Otherwise, hopefully this is enough information to explain the problem - any help is appreciated
- I created the charts via VBA and anchored them to the corners of the cells I want, but lines don't appear uniform length and position within the graph (e.g. 1mo for "a" vs 1mo for "b")
- The values don't seem to be appropriately positioned relative to the min/max values (e.g. the 1 wk graph for "a" has a min of 105, a max of 111 and current of 105 - i'd expect the data pt to be all the way to the left)
- I'd like to add data labels for the min/max values but cant seem to find that option in the Error Bar Options
I'm not married to this graph type so if there's a better option (like a Sparkline?) that will give me the desired behavior, I'm totally open to it. Otherwise, hopefully this is enough information to explain the problem - any help is appreciated
