Bingo, you have a dynamic chart that can be controlled using data filter settings.īrowse more such nifty hacks by reading previous posts in spreadcheats series.Select the type of data you want to use in the chart by applying a data filter. ![]() Now, apply data filters to the source data range (menu > data > filter > auto filter, in excel 2007, use home ribbon > filter & sort button > filter).Doing this will open the Chart Filters window. Once the chart name area is highlighted, you will see the Chart Filters button next to upper right hand side of the chart. This technique is much simpler than dynamic charts using drop-down lists and INDEX formula idea presented earlier. In this excel tutorial shows how to make a scatrer plot in Excel with Step by Step process. Step 2: Click on the Chart Filters button next to the chart. ![]() See this screencast to understand it: (if you cant see it click here) It’s one of the many chart types available in Excel. When you apply a data filter on a chart’s source data, the chart is also filtered. A scatter plot (also known as an XY chart) is a type of chart that shows whether there is a relationship between two variables. Please read other posts in this series to know how you can cheat excel to become more productive at work.ĭo you know that you can create dynamic charts in excel using data filters ? Yes, that is right, we can use data filters as chart filters too. ![]() ![]() This post is part of our spreadcheats series.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |