Forum Discussion
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,...
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
If I may ask though, how did you make the filter at the top? I cant seem to recreate that
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