colour area between 2 curves

I want to create a graph with 2 curves (MG & MP), and when MP > MG, colour the area between the 2 curves in red.

Here is an example with Excel done with this video https://www.youtube.com/watch?v=83o3e_E1j5c&ab_channel=Learnaccess

I have a dataframe with 4 columns: the X series (month), the 2 series for the curves, and the calculated series (MP-MG)

   mois     M.G.  M.P. inv_taux
   <chr>   <dbl> <dbl>    <dbl>
 1 2020-12  33.7  34.5    0.740
 2 2021-01  34.8  35.4    0.540
 3 2021-02  34.3  35.1    0.860
 4 2021-03  34.8  35.2    0.340
 5 2021-04  33.7  35.0    1.36 
 6 2021-05  32.6  33.9    1.27 
 7 2021-06  30.6  32.9    2.30 
 8 2021-07  30.9  33.3    2.43 
 9 2021-08  29.5  32.5    2.97 
10 2021-09  31.5  33.8    2.27 
11 2021-10  33    34.4    1.37 
12 2021-11  32.8  34.3    1.5  

and here is the beginning of the code for my graph

hc<-highchart()%>%
  hc_add_series(data = df, hcaes(x=df$mois, y=df$inv_taux), type='area', stack='normal')%>%
  hc_add_series(data = df, hcaes(x=df$mois, y=df$M.G.), type='line')%>%
  hc_add_series(data = df, hcaes(x=df$mois, y=df$M.P.), type = 'line')
  hc_yAxis(min=0)

Thank you for your help !

Have a look at this article (though it is ggplot2 rather than highcharter):

https://www.nsgrantham.com/fill-between-two-lines-ggplot2

thanks, I'm watching this !

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.