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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies