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)

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

 

[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.