View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
AlphaBravoCharlie AlphaBravoCharlie is offline
external usenet poster
 
Posts: 2
Default How to create chart with TWO categories and one set of data?

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
partment

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