Stacked bars with String and value in them

i want to use stacked bars but i want bars to check a string and value and there is example attached.

at the x there will be 2 values taking a account and the bars will be numbered according to 4 values 2 at the x and 2 at the Y cordinateds but i need to print the name of the city and it alwhttp://www.birt-exchange.org/org/forum/index.php?app=forums&module=post&section=post&do=new_post&f=2#ays changes so i can just put it in or write. i wanted to change according to data i have.

in the expression window i cant put String and value together

row["COUNT_CLOSE_JEOPARDY"]+ row["NAME_OF_THE_CITY"] this doesnt work

"row["NAME_OF_THE_CITY"]" + row["COUNT_CLOSE_JEOPARDY"] or this so kinda stuck

Find more posts tagged with

Comments

asilo1

sorry this is the attachment

mwilliams

I'm not totally sure I'm following. Are we talking about the axis or what's actually in the bar? Can you explain a little more? Maybe if you could reproduce this with the sample database and explain with it, it would help.

asilo1

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="86607" data-time="1322779347" data-date="01 December 2011 - 03:42 PM">
I'm not totally sure I'm following. Are we talking about the axis or what's actually in the bar? Can you explain a little more? Maybe if you could reproduce this with the sample database and explain with it, it would help. </blockquote>
 
 
 
was thinking of realating one column to 3 variables and each row in the column 2 variables. 
 
example 
 
car company car model car color car amount

mwilliams

asilo1

all i want to know is how can i put a string and number inside of a bar. and manage them according to string and number. so when ur creating a expression fro value (y) series you cant seem to put string but i need number and string.

mwilliams

Take a look at this example. It adds a string value to the label inside the bar. You could do the same with the y-axis labels if needed.

asilo1

i couldn't find what would change the strings and what i wanted to know originally, is there anyway i can forexample put city names in the countries and divede them by population. like canada---> sk , alberta, ontario inside the bar with city name and population. which will be changing all the time.

mwilliams

Like this?

asilo1

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="93886" data-time="1326234173" data-date="10 January 2012 - 03:22 PM">
Like this? </blockquote>
 
 
thanks a lot thats what i was looking for.

mwilliams

You're welcome. Glad to help.