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

  • ExcelNovice2319's avatar
    ExcelNovice2319
    Copper Contributor
    Nov 11, 2022
    If I may ask though, how did you make the filter at the top? I cant seem to recreate that
    • tauqeeracma's avatar
      tauqeeracma
      Iron Contributor
      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

Resources