I could really use some help here—I’ve been banging my head against the wall with this one and just can't seem to get it right
I'm trying to add a specific target line to an Excel bar chart—basically an "optimum" value line
For instance, if my Y-axis runs from 1 to 10, I want to draw a horizontal line at 5.5 so I can easily see which bars cross that threshold. I actually found a way to draw a line, but it's not quite working for me—it doesn't scale with the graph, so when the chart scales or changes shape, the line stays stuck in its original spot. Does anyone know the proper way to make this work?
I'm trying to add a specific target line to an Excel bar chart—basically an "optimum" value line
For instance, if my Y-axis runs from 1 to 10, I want to draw a horizontal line at 5.5 so I can easily see which bars cross that threshold. I actually found a way to draw a line, but it's not quite working for me—it doesn't scale with the graph, so when the chart scales or changes shape, the line stays stuck in its original spot. Does anyone know the proper way to make this work?