2 criterias to organize data by VLookup

Originally Posted by douglascaixeta

- X: Time
- Y: Value
- Bubble: Item
- Size of bubble: Value
- Color of bubble: company

Again, you are trying to assign value to both Y, and Size of Bubble.
And you say "Bubble: Item." Bubble is not a parameter that you can assign values to.

You may try to assign Item to Y axis, and value to size of bubble.
But then, you'll have the problem that since item is a string (text) value, excel won't allow you to make an axis out of it.
You can try to assign a number to represent each item, if the graph would then make sense to you.
I have done this, in the attached workbook.

However, as I said before, I think this kind of a complicated graph will not make any sense to the user, because you're trying to control for too many things in one chart. The right thing to do would be splitting variables of interest to different charts.

P.S Note that I have also done a scatter plot, which does not account for the variable: item. You can also do other charts, looking at other variables; it all depends on what you want to analyze.