CODEWITHSUNDEEP
excelsortinggraphcolumn-chart
lingo124
lingo124

Reputation: 3

Need Help Creating Excel Sorted Chart By Type

I have data of the form

Type Car Hours Worked

I would like a column graph to show the type of car in each column, and the time worked on each car within that specific type. So for example, I would have 3 columns (coupe, sedan, convertible), and within each column I would have multiple sections showing each car within that type.

How would I do that?

thanks

Upvotes: 0

Views: 30

Answers (1)

NikG
NikG

Reputation: 111

Try a PivotChart - it can summarize the results based on vehicle type in a column graph.

Upvotes: 2

Related Questions