Pyramid like Bar Charts
Hi,
Assume the Head Count of People in various Grades are as follows:
A-1000
B-250
C-100
Is it Possible to implelment the same using Bar Charts as shown below:
______
_____|______|____C
______________|_________________|_____B__________
|_________________________________________________| A
February 8th, 2011 1:58am
Hi,
You can achieve it with a Stacked Bar chart. In example, you can define the following SQL dataset:
SELECT 'C' AS description, 450 AS fPoint, 100 AS sPoint
UNION
SELECT 'B' AS description, 375 AS fPoint, 250 AS sPoint
UNION
SELECT 'A' AS description, 0 AS fPoint, 1000 AS sPoint
Then, put this in a Stacked Bar with values as fPoint and sPoint and category - description.
Once it starts working simply change the color of the left series to White.
Boyan Penev --- http://www.bp-msbi.com
February 12th, 2011 2:45am