deepakgoyal2005
Board Regular
- Joined
- Sep 1, 2008
- Messages
- 58
Need to create a bar chart for table having following 3 columns
[TABLE="width: 195"]
<tbody>[TR]
[TD]Account[/TD]
[TD]Project#[/TD]
[TD]Headcount[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]2[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]5[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]3[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]
The bar chart need to have bars and data label for project#. Additionally on top of the Project# label it should have another label for Headcount with an icon to differentiate
I tried having Project# shown as bar against the primary X-axis and Headcount on secondary axis as "Stacked Line" made invisible by removing color. This gives me just the numbers which still needs to be adjusted manually to be shown over the corresponding project# label.
Problems:
1) Manual adjustments are required every time the numbers change
2) No idea how can the Headcount label have a particular icon before it
[TABLE="width: 195"]
<tbody>[TR]
[TD]Account[/TD]
[TD]Project#[/TD]
[TD]Headcount[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]2[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]5[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]3[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]
The bar chart need to have bars and data label for project#. Additionally on top of the Project# label it should have another label for Headcount with an icon to differentiate
I tried having Project# shown as bar against the primary X-axis and Headcount on secondary axis as "Stacked Line" made invisible by removing color. This gives me just the numbers which still needs to be adjusted manually to be shown over the corresponding project# label.
Problems:
1) Manual adjustments are required every time the numbers change
2) No idea how can the Headcount label have a particular icon before it