Question Regarding Line graphs

[Lgitonga]

Hi....
I have a rather simple and quick question...
Is there a way to have a single line graph to have 2 separate colors depending on some conditions being met...

Example: https://gyazo.com/75d66954bf97f2095def1e3fe981ed7e
graph line.png

So ... if i wanted trade # 200 to current trade # 337 to have a different color say GREEN or RED instead of the current pink color graph...How can i achieve this task?

It should have a mix of 2 colors showing back-testing period i.e upto Trade # 200 (a pink color) and forward testing period i.e from trade # 201 to most recent trade #337 ( a green color).

Is there a way i can achieve this task i ask again....

Really looking forward to your response....

Thanks guys

[MrShorty]

IMO, conditional formatting of charts is most easily done in the spreadsheet. You separate your "conditions" into separate helper columns, then add those helper columns as individual series. It is then very easy to format each series the way you desire. Example and more detailed discussion here: http://peltiertech.com/conditional-f...-excel-charts/