create several chart and command button for show one of them

[niksirat2030]

I have an Excel with two sheets, Form and DATA, and I designed a form in the Form sheet.

My data is in A1:B10 and D1:E10 in the DATA sheet.

I put two command buttons in the Form sheet whose names are cmdButtonChart1 for the chart related to A1:B10 and cmdButtonChart2 for the chart related to D1:E10.

My goal is that when each button is pressed, the previous chart will be hidden and the bar chart corresponding to that button will be displayed in the Form sheet.

Until now, I have not written the commands related to chart in VBA. Please help me to write that.

Thanks in advance.

 

[Fluff]

Once again you have cross-posted without supplying a link. Please do so now.
Should you fail to provide links in the future you could find yourself being banned.

 

[niksirat2030]

Once again you have cross-posted without supplying a link. Please do so now.
Should you fail to provide links in the future you could find yourself being banned.

In that site, I referred to this post.

Asked this Q in this place.

 

[Fluff]

In that site, I referred to this post.

Yes but you must post links here as well, without being asked.

 

[niksirat2030]

Just warning for Cross post. There is no help to solve my problem