Want to create 2 columns (A and B) and the data within A is further divided in 3 groups. We have to plot a scatter graph against column B such that the 3 groups can be distinctly identified.
Create a filter on the column with the group categorization. When the column is filtered for a particular group, only that group's data will appear in the scatter plot.
Excel Business Forums Administrator
Posted by Excel Helper on
Displaying page 1 of 1
Excel templates and solutions matched for Basic Excel data categorization: