Embedding a vertical reference line in chart
Solution 1:
Here is a bit of a workaround, not ideal, but could do the job. Let me know if it works for you
- Insert a 3rd column for the cutoff in your table with a value equivalent to the the max value of your axis (in this case,
7000
)
- Insert a combo chart with the third series as columns
-
Select the bar and adjust width and colour by Formatting the Data Series
-
Format the left Axis so the range is between
0
and7000