Excel chart - horizontal graph
Budget: $10 – $30 USD
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. Sample data and images attached, 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
- 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