VBA create dynamic graph from two columns

[papakos]

Here is my problem

I have a user form contains a ListBox that been populated from column A. It's ok fixed that.
I have 3 commandbuttons (TEMP, HUMIDITY,RAIN) and one PictureBox.
I'm trying to create a graph that contains x axis= Jan, Feb, Mar, Apr, May, Jun and y-axis the values from cells under TEMP etc
The graph will be displayed in PictureBox when i press one of the 3 commandButtons and will be depending from the selection of ListBox(ALASKA etc)

		TEMP	HUMIDITY	RAIN
ALASKA	JAN	-5	95	154
	FEB	-7	92	124
	MAR	1	88	88
	APR	5	74	54
	MAY	9	65	22
	JUN	18	48	1
ALABAMA	JAN	3	45	25
	FEB	7	58	38
	MAR	14	55	24
	APR	19	43	58
	MAY	22	23	41
	JUN	25	21	7
BOSTON	JUN	1	65	69
	FEB	3	76	58
	MAR	4	68	41
	APR	9	59	34
	MAY	14	39	4
	JUN	22	33	2
TEXAS	JAN	8	78	18
	FEB	11	65	21
	MAR	13	45	5
	APR	20	31	4
	MAY	24	29	0
	JUN	31	23	1

<tbody>
</tbody>

 

[papakos]

NOT even 1 answer????????

 

[thisoldman]

papakos, you haven't clearly stated your problem or asked a question. What have you tried and where are you running into difficulty?

You have a typo in your posted data: BOSTON has two JUNs.

Your data layout in post #1 may reflect your spreadsheet layout. While blank rows and empty cells sometimes make it easier for humans to read, that layout creates difficulties when we use a computer to sort and filter the data. Formulas and programs are much easier to write when a flat file data structure is used.

If you're having problems creating the dynamic chart, I've posted a non-VBA spreadsheet using your data at https://www.dropbox.com/s/256t23m52xgmo5b/2017-12-19_weather_dynamic_chart.xlsx?dl=0. I've used data validation dropdowns for the user to select the data to display.

I am sorry I can't help you transfer the chart to your VBA userform, but perhaps what I've shown in my spreadsheet will help you.