LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
column chart with 3 categories martymi Charts and Charting in Excel 2 May 1st 07 07:29 PM
Bar chart with Y Axes Categories MB Charts and Charting in Excel 6 February 20th 07 09:58 PM
Create Stacked column of multiple values across categories Elynn Charts and Charting in Excel 3 November 12th 06 09:01 AM
Chart Categories SJT Excel Discussion (Misc queries) 1 June 19th 06 08:13 PM
3D chart categories elementary Charts and Charting in Excel 0 May 22nd 06 06:59 PM


All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"