Draw horizontal line in a line chart with a single cell value
Posted on 2011-02-25
I would like to use a line chart to create a horizontal line from the same cell value. The only way I can figure out how to do this is to place the same value in many rows and select them as the line charts series. It works but it's cumbersome and I don't like the idea of a whole column dedicated to a redundant value that is in another cell.
Is there a way to tell a line chart to use a single value for x series?