2 criterias to organize data by VLookup

Originally Posted by douglascaixeta

I used your last graph, the one that identifies the company as circle, square, triangle, and just turned into bubble graph, and reduced the bubble size to 10. Bubble size doesn't matter as Y already shows the value.

If you have done this, it means bubble size is set to the same value for all items; and hence, it means you are not using the variable "item" in your graph, hence; it means you have reduced the number of variables to three, as I have suggested in the first place.

Originally Posted by douglascaixeta

One last question: Is there an easier way to create the bubble graph ? The way I'm doing it, I need to select serie by serie. The data of each company separated. With 500 registers that will be a huge problem.

Since you want to organize the graph this way, you need to select the data range for each series individually.
However, if updating the chart range manually everyday is a trouble that you want to eliminate, you can use "dynamic named ranges" .
See the following link:
http://office.microsoft.com/en-us/ex...001109801.aspx

P.S: To use the "dynamic named ranges" as described in the link, you should reorganize your data, such data each company data is on a different column.
You'll understand what I'm talking about when you read it.