On Thu, 23 Aug 2007, in microsoft.public.excel.charting,
AlphaBravoCharlie said:
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

You need two Salary columns: the first is minimum salary. e.g. in
Finance the minimum salary for Engineers is 25; in HR the minimum salary
for Engineers is 30. The second salary column you need is the range.
e.g. in Finance the range for Engineers is 35; in HR the range for
Engineers is 10.
Min Range
Finance Engineers 25 35
HR Welder 15 3
HR Engineers 30 10

Now create a Stacked Column Chart that stacks the range on top of the
minimum, and format the minimum column so that it is invisible (no line
or area color)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.