1

I am using a combo chart and I have managed to reach as shown below

enter image description here

Below is the output that I am seeking. I am trying to add a vertical line for a specific date (say 11th Jul)

enter image description here

I googled a lot but unable to find a solution. I came across something which is closer to what I need. Embedding a vertical reference line in Excel but I am unable to achieve this as there is already a secondary axis. What is the best way to handle this?

Dhruva
  • 435

1 Answers1

2

Here is a bit of a workaround, not ideal, but could do the job. Let me know if it works for you

  1. 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)

enter image description here

  1. Insert a combo chart with the third series as columns

enter image description here

  1. Select the bar and adjust width and colour by Formatting the Data Series

  2. Format the left Axis so the range is between 0 and 7000

enter image description here

cybernetic.nomad
  • 5,951
  • 15
  • 26