Home

Multiple Charts for the same range of data in multiple tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-480504%22%20slang%3D%22en-US%22%3EMultiple%20Charts%20for%20the%20same%20range%20of%20data%20in%20multiple%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480504%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20multiple%20chart%20for%20the%20same%20range%20of%20data%20in%20different%20tabs.%20I%20tried%20to%20use%20the%20Macro%20recorder%20but%20it%20wants%20to%20use%20the%20same%20range%20of%20data%20in%20the%20original%20tab%20where%20I%20made%20the%20recording.%20I%20would%20just%20like%20to%20use%20one%20macro%20and%20go%20down%20through%20the%20individual%20tabs.%20Any%20help%20is%20appreciated.%20My%20macros%20skills%20are%20very%20beginner.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-480504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-480522%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Charts%20for%20the%20same%20range%20of%20data%20in%20multiple%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480522%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325005%22%20target%3D%22_blank%22%3E%40KFowlow%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi!%20if%20you'd%20like%2C%20paste%20the%20macro%20that%20you%20have%20already%20and%20let%20me%20know%20what%20are%20the%20names%20of%20the%20sheets%20from%20which%20you%20want%20the%20macro%20to%20grab%20data%20for%20a%20chart.%20Please%20tag%20me%20so%20that%20I%20come%20back%20to%20his%20thread.%3C%2FP%3E%3C%2FLINGO-BODY%3E
KFowlow
Occasional Visitor

Hi All,

I'm trying to make multiple chart for the same range of data in different tabs. I tried to use the Macro recorder but it wants to use the same range of data in the original tab where I made the recording. I would just like to use one macro and go down through the individual tabs. Any help is appreciated. My macros skills are very beginner.

 

Thanks,

1 Reply

@KFowlow 

Hi! if you'd like, paste the macro that you have already and let me know what are the names of the sheets from which you want the macro to grab data for a chart. Please tag me so that I come back to his thread.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies