Macros and histograms [Closed]

Report
-
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
-
Hello,

I want to create a histogram on sheet2 while the data required is on sheet1 using a macro. everytime I try, it either says no data available or output and input are the same, depending what sheet is open when the macro is run. While looking at the VBA it only references ActiveSheet.Range. I've tried renaming the activesheet to the sheet name but this doesn't work. Is it possible to do what I want or can you only create a histogram on the same page as the data? Any help would be greatly appreciated.

1 reply

Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460
Hi lufc66,

The graph and data do not need to be on the same sheet.

What code are you using?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!