Forum Discussion

harshinishetty's avatar
harshinishetty
New Member
4 years ago

Stacked Area chart with line chart

Dear All,

I need a stacked area chart and line chart as you in the below picture. 
Here the line charts refers to only one value and area chart will get added up as per the selection from slicer.
Can some one give me an idea on this? Thanks in advance

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi harshinishetty ,

     

    I think you can try Line and clustered column chart. Add all columns you need in Line field.

    Line and clustered column chart >  Shapes > Turn on Customize series> Select the column you want to show area to turn on Shade area.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Hi Anonymous 

    Thank you for the response. 

    Please help me to find the path Line and clustered column chart >  Shapes > Turn on Customize series as i could not find in the visual formatting section.


    Thank you