Need to show RANGE of data in TWO CATEGORIES

A

AlphaBravoCharlie

One cata ategory is GROUP another category is DEPARTMENTS and the data looks
as under:

Dept Group Salary
=== ===== ====
Finance Engineers 25
Finance Engineers 40
Finance Engineers 60
HR Welder 18
HR Welder 15
HR Engineers 30
HR Engineers 35
HR Engineers 40

How can I create a CHART so that it shows the RANGE of salary per Department
per Group?
In other words in department Finance the Salary range of engineers is
between 25 and 60.

In department HR the salary range of Engineers is between 30 and 40
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top