Chart

[Penelope74]

Hi All,

I've series of products data (Product Red, Green...), divided in Region (PACIFIC ASIA)) countries (China, Australia, Bangladesh...) and year (2010-2017).

		2010	2011	2012	2013	2014	2015	2016	2017	Grand Total
PRODUCT RED		0	0	0	0	1	0	0	0	1
	China	0	0	0	0	1	0	0	0	1
PRODUCT GREEN		15	13	3	23	5	8	6	0	73
	Australia	0	1	0	0	0	0	0	0	1
	Bangladesh	1	0	1	0	0	0	0	0	2
	China	8	10	1	20	4	0	2	0	45
	India	3	0	0	0	0	1	1	0	5
	Indonesia	3	0	0	0	0	0	0	0	3
	Japan	0	2	1	1	0	6	3	0	13
	Malaysia	0	0	0	0	1	0	0	0	1
	South Korea	0	0	0	2	0	1	0	0	3
PRODUCT YELLOW		4	0	3	0	3	0	0	0	10
	China	0	0	1	0	0	0	0	0	1
	Japan	4	0	2	0	3	0	0	0	9
PRODUCT WHITE		2	0	0	2	0	2	14	0	20
	China	0	0	0	2	0	1	13	0	16
	Malaysia	0	0	0	0	0	0	1	0	1
	Thailand	2	0	0	0	0	1	0	0	3
		42	26	12	50	18	20	40	0	208

<colgroup><col><col><col span="8"><col></colgroup><tbody>
</tbody>

I need now to represent those data in a chart (BUBBLE?), that shows for the Area - the growth of the product in each country in order to understand for example, if the product green - very strong in China in 2010 has been sold in the following years in other countries and if in China has been replaced by other products.
In synthesis, I need to know for all this products "what is going where"

I hope my explanation is clear

 

[thisoldman]

Hi, welcome to the forums.

I'm afraid your description is not clear to me.

What goes on the x-axis, the horizontal axis?
What goes on the y-axis, the vertical axis?
How is "growth" measured? How do you want to show positive, zero, and negative values?

 

[Penelope74]

Hi, welcome to the forums.

I'm afraid your description is not clear to me.

What goes on the x-axis, the horizontal axis?
What goes on the y-axis, the vertical axis?
How is "growth" measured? How do you want to show positive, zero, and negative values?

Thanks a lot for your kind reply.
I solved the problem

 

[thisoldman]

Glad to hear you have your solution.