IChart Group bar data mapping problem?

[HariCS23]

Hi Guys,

I am totally confused what give in the data mapping and x-axis,y-axis tabs.

I am getting data like

Product             on hold          processing                 completed            scrap        
-------------------------------------------------------------------------------------------------------------------
Prod1                     3                       7                              8                      6
Prod2                     8                       4                              3                      6
Prod3                     1                       2                              7                      7 
.
.
.
.
.

Like i would get products and 4 values for that.

I want to show that data in Group bar chart :

On x axis : i want display bars for onhold,processing,completed,scrap for each product.

Please help me.

Vansi

[jcgood25]

Since these are your numeric fields you need them to be the ValueColumns: on hold, processing, completed, scrap

To make them dynamic based upon how many Products you have, Product should be your LabelColumns

[HariCS23]

Thanks jeremey for the reply.

If i do that. i am getting legend for Products ( So, for each product i am getting diff color ).

But i want to have different color for the 4 bars of each Prodct.

What i am getting :

<C1>  Bar1 Bar2 Bar3 Bar4    <C1>     <C2> Bar1 Bar2 Bar3 Bar4<C2> 
X-------------------------------------------------------------------------------------------------------------------------
....for all the products.

Legend: C : Prodct1
             C2 : Product 2
   ......     C3  : Prodct 3



But i have the requirement 

<C>bar1<C1> <C2>bar2<C2>  <C3>bar3<C3> <C4>bar4> <C4> .....for each product.

Legend : C1:  Onhold
              C2 : Processing
              C3: Copmleted 
              C4 : Scrap

Do need different for of data output ( i.e do i need to do any row column tranformmation)

Thanks in advance

Vansi

[jcgood25]

Take Product out of the LabelColumns, then you will have a pen for each of the value columns specified.

If you enable MouseTracking and put Product into DatalinkColumns the product name will appear in the upper left hand corner of the chart as the user moves the mouse over the bars.

If you put Product into AxisLabelColumns then the Prodx will show up below each of the bars (they show the number by default). This will get a little messy if you have a ton of product rows in your query results, so the MouseTracking might be a nice setup too.

Regards,

Jeremy

[HariCS23]

Thanks you very much jermy.

I am working in xMII 12.0, i couldn'tfind place where i chnage the pen colors.

Could you where is that?

Thanks

Hari

[jcgood25]

Apparently the translators in Germany didn't want to call them Pens, so look on the Data Series Details tab, and each of the 32 Pens is now considered a Data Series ID.