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!
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
please post the file to answer you or print screen
ASKER
Hi,
Here it is under the tab "English"
And the Graphic is "VÉ vs GAS".
Thanks!
Here it is under the tab "English"
And the Graphic is "VÉ vs GAS".
Thanks!
ASKER
Here's the kind of visual I'd like to get:
SOLUTION
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.
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
I'll try again to attach files...
Expert-Exchange-Ne-pas-ouvrir-pour-.xlsx
expert-exchange-2016-09-29-11_06_06-.jpg
ASKER
Sometimes it looks like this:
![expexch2.jpg]()
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.
This series can then be converted to a column chart rather than a line and set to be show a very thin column.
ASKER
@Rob:
I don't understand...
If I do a "Garder"-"switcher" I get this:
![expExch2.jpg]()
And if I do an "IF 0 and 1 I get this:
![expExch3.jpg]()
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
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.