Combo Charts

New Contributor

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, Th, Fri, Sat, Grand total in that order. Under Reason I have 10 different text reasons, and the days are populated with numerical data. I want the reasons to be the column part of my graph with the grand total making it up. I want a line chart than can be filtered by day that bounces from one reason to the next. If anyone has any feedback on how to format it I'd much appreciate it!

 

 
 

 

 
 
 
 

 

 

4 Replies

Hi @ExcelNovice2319 

 

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

tauqeeracma_0-1668140817449.png

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

 

Thanks

Tauqeer

This is perfect! thank you for your help! @tauqeeracma 

If I may ask though, how did you make the filter at the top? I cant seem to recreate that

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.

 

tauqeeracma_1-1668187206897.png

 

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

 

 

Thanks

Tauqeer