Forum Discussion

ExcelNovice2319's avatar
ExcelNovice2319
Copper Contributor
Nov 10, 2022
Solved

Combo Charts

I am attempting to overlay a line chart on top of a column chart that filters by the day. I cannot upload a picture of sample data for some reason but my table has the headers: Reason, Mon, Tue, Wed,...
Charting
  • tauqeeracma's avatar
    tauqeeracma
    Nov 11, 2022

    Hi ExcelNovice2319 

     

    You can insert a filter (List-of-Values) in excel using the below steps:

     

    Go to the cell where you want to insert the filter (in this case C2), then

    Select Data > Data Validation > List > [actual data]

     

    You may refer to the screenshot for more clarity.

     

     

    In the SOURCE field, you have options either to manually input the values or define a range.

     

     

    Thanks

    Tauqeer

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Nov 11, 2022

Hi ExcelNovice2319 

 

First, with the help of Index() & MAtch() functions you can arrange your data, and then you can easily make a combo chart.

Please refer to the attached sample file and let me know if it works for you.

 

Thanks

Tauqeer

Resources