how to add supplier info to scatter plot

[#1]

Hello Everybody,

I am trying to solve the follwing problem.

I set up a scatter chart indicating price (y axis) and quantity purchased (x axis), as a dimension I use the article number.

Now I would like to add the information "supplier name" to the data point or highlight all data point from the same supplier with the same color. Goal is to visualize where the articles of the different suppliers are located in the scatter chart.

i.e. Supplier A: Down right (high quantity, low price) or Top left (low quantity, high price) etc.

Anybondy can help me?

Thanks much in advance.

Best Regards,

beat

[swuehl · Accepted solution]

For the background color attribute expression of the X axis expression, try something like (assuming Supplier as supplier field name):

=Color(FieldIndex('Supplier',Supplier))

[HirisH_V7]

Hi

Check out the Attachment.

Hope this Helps ,

Regards,

Hirish

[#4]

Thank you guys for your answer.

When I put in the "=Color(FieldIndex('Supplier',Supplier))" using "Lieferantenname" as "Supplier. Now all data points (articles) turn black although in the underlying excel column (Lieferantename) there are a number of different supplier names.

I insert a screenshot. What am I doing wrong?

[HirisH_V7]

Hi beat,

Did you got your desired Result!

-Hirish

[#6]

Hi Hirish

Unfortunatly not yet, see my 2nd post above.

Can you think of a solution? or what I am doing wrong?

Thanks much in advance.

Best,

Beat

[swuehl]

If your field is named Lieferantenname, you should also use this as field name in FieldIndex() function:

=Color(FieldIndex('Lieferantenname', Lieferantenname))

Or what is the relation between Lieferant and Lieferantenname and are the field values the same?

[#8]

Perfect. Now it works. Thank you for your support.

Best,

Beat