• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to creat a Scatter with multiple series

T

Thanos

New Member
Hello there,

I am currently trying to create a Scatter chart for the following type and number of data.
I have around 600 different products with random gross margin profit and random contribution to the company's total revenue.
I would like to express on the x-axis the contribution to the revenue in % and on the y-axis the individual gross margin profit. At the same time I need all these products to be expressed as different markers on the chart in order to be able to spot specific products.
According to my understanding I need to import all these products as different series in order to have all the numbers of products in the legend but I cannot figure out how to do it.
When I say products, i am not that crazy to want theit full names on the chart. I will be happy enough having just a number which identifies each of them (1,2,3,4,5,6,....etc).
Please find attached my file and enlight me!

Many many thanks,
Thanos (Greece)
 

Attachments

You can only have 256 series in a scatter chart and so I thought the above method may be better
 
Many thanks Hui. Its really helpful.
The only reason I wanted to plot it using multiple series its because I need a printed version of the scatter where I cannot click on the spots to figure out which product they represent.
Anyhow...Got a bit dissapointed when I read the message about the limitation of the 256 series...
Keep up the good work...You really make people awesome on excel! :-)
 
You must log in or register to reply here.
Back
Top