Home > Forum Home > Automating Data Analysis Tasks > Basic Excel data categorization Share

Basic Excel data categorization

Excel Help for Basic Excel Data Categorization in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Basic Excel Data Categorization

Rate this:
(3/5 from 1 vote)
ConfusedWant 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.
 asharma
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
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 on
 Displaying page 1 of 1 

Excel templates and solutions matched for Basic Excel data categorization:

Solutions: Business Valuation Model Chart Help