Forum Discussion
How to select certain data in a column to put in a graph in excel
If I were to have a column, say of 2000 males or females, entered in a column (in a random order), and their income in another column, how would I select only the data so that I can create a scatter plot of females and their income? Without manually picking out and selecting all the females.
3 Replies
Use the FILTER function to extract the data for Gender="female" to a separate range, and use that for the chart.
(FILTER is available in Excel in Microsoft 365 and Office 2021, and also in the online version)
- Thanks, so I tried that and it did give me all the rows with female and income, however, when i change the filter to male the graph automatically changes too, as I need a scatter plot for both male and female
What do you want to plot on the axes? One would be income, but the other?
