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 ...
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?