Hi all,
Sorry to bother you guys with a (simple?) problem. I'm not entirely new to VBA but new enough that I am a noobie compared to everyone here.
So what I'm envisioning is this:
1) Let's say I have 2 worksheets. Worksheet 1 and Worksheet 2. Worksheet 2 is HIDDEN but has DATA in it. For example, Column A has 1-20. Column B has =rand()*100.
2) Let's say you make a bar chart with the two columns of data manually. You go to insert --> bar graph = bar graph with x-axis 1,2,3...20 etc. That's the end product that I want. BUT I want to do all that in 1 click of a button.
3) Let's say I make a userform OR an activeX command button in Worksheet 1 (where there's no data). I click the button and the graph just pops up in worksheet 1 with all the data in 2. Is that possible??
Thanks so much in advance guys!
Bookmarks