Macros and histograms

Closed
lufc66 - Feb 8, 2012 at 12:23 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 9, 2012 at 10:35 AM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Feb 9, 2012 at 10:35 AM
Hi lufc66,

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

What code are you using?

Best regards,
Trowa
0