create 3 charts from userform

[H_Kennedy]

Hi

Can it be possible to change this code so that when Userform is selected that it creates 3 charts simultaneously for the date selected.All created on the same date..It creates Group A,Group B and Group C into there designated chart areas.The Charts area remain in the sheet all times and only Columns added and removed. The first chart does this already it is the next 2 charts which need adding

Thank you

[Bhuvi]

Hi H_Kennedy,

Would you be interested in a solution without macros & userform?

If yes , then you can use the attached file. Change the date in cell D2 and all 3 charts get's refreshed.




<if this helped, please click on the Star * below this post to say thanks>

[H_Kennedy]

Thank you
Bhuvi

That is very good but I would like to see a macro/userform version as I plan to tie this in with another code

I will be able to use your solution though for another Chart workbook.The dates do not move though when changing dates?

Thanks again

[Bhuvi]

Hi H_Kennedy,
You can request the admin to move your post to excel Programming/vba/macros section. Someone may help you over there.