View original (French)

STACKED HISTOGRAM WITHOUT CUMULATIVE VALUES

Caroline_2712 Posted messages 1 Status Member -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello,

I need to create an Excel chart in "stacked column" format with the following data:

Revenue for the month in the portfolio
Lead/lag vs. 2019
Lead/lag vs. budget
This over the next 3 rolling months

Can you help me because I'm unable to produce this chart as I want.

Example

July
Revenue 2022 in the portfolio €1,000
Lead/lag vs. 2019 €200 ( = revenue 2019 to date €800)
Lead/lag vs. budget +€500 ( = budget 2022 €500)

The revenue in the portfolio must be the reference value, and in 'hatched' format, the lead/lag vs. 2019 & budget should appear in each column
If the portfolio revenue is ahead of 2019 & budget then the lead values (+€200 vs. 2019 & +€500 vs. budget) will be integrated proportionally to their value in the column of revenue 2022
If the 2022 portfolio revenue is behind then the values of the "remaining revenue" needed to reach the 2019 revenue and/or budget will appear hatching "above" the value of the 2022 portfolio revenue.

Thank you very much in advance for your help
I hope my explanations were clear enough

Best regards,

Caroline

2 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello Caroline

    An example to adapt to your file (if I understood everything correctly)
    https://www.cjoint.com/c/LFDntfWkJDJ

    Best regards
    Via
    --
    "Imagination is more important than knowledge." A. Einstein
    0
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Hello to both of you, and well done Via: I think you understood everything, and the graph meets the request.

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0