I have an excel chart in which some lines are filled in green, red or blue. All I want is a filter with which I can hide the lines of one or more colors. It really shouldn't be that difficult. But I can't make it. Can someone help me. Thanks.
I have an excel chart in which some lines are filled in green, red or blue. All I want is a filter with which I can hide the lines of one or more colors. It really shouldn't be that difficult. But I can't make it. Can someone help me. Thanks.
select filter and apply, in the dropdown for the filter selections should be the ability to apply the filter by color, you should be able to select none - showing all, or cell color or font color. cell color should allow you to exclude all colors except one specifically or all the colors and exclude those not colored. Hope that helps.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."
A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.
Since you are a new user of this site, on this occasion, I have changed it for you.
However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.
*Other search engines are available!!!
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks