asked on

# How to highlight an Excel graph lines crossing?

I made a simple excel graph with 2 lines showing the cumulative costs of a gaz car costs and an electric car cumulative costs.

On the horizontal you see the years   (2016 2017 2018 2019 2020...)

And on the vertical line you see the cumulative costs ( 10,000 20,000 30,000 ....)

In this exemple, you see that the electric car starts more expensive but after 3 years, the line crosses the gas car line so you know that after 3 years, your return on investment pays off.

How can I have Excel do a vertical line pointing to the date the return on investment pays off?
Thanks!
Microsoft ExcelMicrosoft OfficeOffice Suites-Other

Last Comment
Rob Henson

8/22/2022 - Mon
Saadia Attias

please post the file to answer you or print screen
philjans

ASKER
Hi,
Here it is under the tab "English"
And the Graphic is "VÉ vs GAS".

Thanks!
philjans

ASKER
Here's the kind of visual I'd like to get:
SOLUTION
Glenn Ray

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
philjans

ASKER
... this site still hard to figure out... I just posted 2 comments with 1 attachement each but I don't see any attachement here....
I'll try again to attach files...
Expert-Exchange-Ne-pas-ouvrir-pour-.xlsx
expert-exchange-2016-09-29-11_06_06-.jpg
philjans

ASKER
Sometimes it looks like this:
Rob Henson

Add a 3rd series to the chart data which compares the two values for series 1 & 2. For the screen shot above you would want the value to appear in the cell where Garder >= Switcher.

This series can then be converted to a column chart rather than a line and set to be show a very thin column.
philjans

ASKER
@Rob:
I don't understand...
If I do a "Garder"-"switcher" I get this:

And if I do an "IF 0 and 1 I get this:
ASKER CERTIFIED SOLUTION
Rob Henson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.