Home

Excel spreadsheet tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-870197%22%20slang%3D%22en-US%22%3EExcel%20spreadsheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870197%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%20All%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EI%20was%20wondering%20if%20someone%20can%20assist%20me%20on%20how%20to%20separate%20%3CFONT%20color%3D%22%23FF00FF%22%3Etabs%3C%2FFONT%3E%20on%20a%20spreadsheet.%20I%20am%20currently%20working%20on%20%3CFONT%20color%3D%22%23FF00FF%22%3Eone%20spreadsheet%3C%2FFONT%3E%2C%20I%20have%20%3CFONT%20color%3D%22%23FF00FF%22%3E3%20tabs%3C%2FFONT%3E%20all%20exactly%20the%20same%20just%20the%20content%26nbsp%3B%3C%2FFONT%3E%3CFONT%20color%3D%22%23FF00FF%22%3E%3CSPAN%3Ediffer%3C%2FSPAN%3E%3C%2FFONT%3E%3CSPAN%3E%3CFONT%20color%3D%22%23FF00FF%22%3Es%3C%2FFONT%3E%2C%20every%20time%20I%20want%3CFONT%20color%3D%22%23FF00FF%22%3E%20view%20the%20graph%3C%2FFONT%3E%20table%20it%20only%20picks%20up%20on%20the%20%3CFONT%20color%3D%22%23FF00FF%22%3Efirst%20tabs%3C%2FFONT%3E%20info.%20I%20need%20each%20tab's%20graph%20able%20to%20work%20individually.%20I'm%20very%20new%20to%20excel%20and%20all%20it's%20wonderful%20uses%2C%20please%20assist%20me.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EKind%20Regards%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-870197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871758%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20spreadsheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871758%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413571%22%20target%3D%22_blank%22%3E%40Vall_Bell1402%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20are%20you%20saying%20you%20have%20a%20graph%20on%20tab%20one%20and%20you%20want%20to%20replicate%20that%20graph%20onto%20tab%202%20and%20tab%203%20with%20the%20data%20being%20picked%20up%20from%20those%20sheets%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874113%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20spreadsheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874113%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%3C%2FP%3E%3CP%3EThank%20goodness.%20That%20is%20exactly%20what%20I%20would%20like%20to%20do.%20So%20far%20I%20have%20already%20%3CFONT%20color%3D%22%23FF00FF%22%3Ecopy%3C%2FFONT%3E%20and%20%3CFONT%20color%3D%22%23FF00FF%22%3Epasted%3C%2FFONT%3E%20the%20table%2C%20I%20need%20help%20to%20convert%20the%20right%20information%20to%20all%20corresponding%20tabs%2C%20and%20still%20have%20the%20%3CFONT%20color%3D%22%23FF00FF%22%3Egraph%20working%3C%2FFONT%3E%20with%20all%20%3CFONT%20color%3D%22%23FF00FF%22%3ESUMS%20added.%3C%2FFONT%3E%20The%20graph%20also%20has%20a%20%3CFONT%20color%3D%22%23FF00FF%22%3Efiltered%20select%3C%2FFONT%3E%20list%20for%201st%20Quarter%2C%202nd%20Quarter%20ect.%20How%20do%20I%20configure%20the%20select%20list%20to%20filter%20each%20table%20accordingly%3F%3C%2FP%3E%3CP%3EI%20hope%20you%20understand%2C%20thanks%20a%20mil%20for%20your%20response!%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874175%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20spreadsheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874175%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20would%20help%20if%20you%20could%20post%20a%20sample%20file%20and%20or%20some%20screenshots%20to%20help%20me%20understand%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874204%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20spreadsheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874204%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20very%20grateful%20for%20all%20your%20help.%3C%2FP%3E%3CP%3EPlease%20see%20below%20a%20screenshot%20of%20the%20Spreadsheet.%20Keep%20in%20mind%20I%20have%20%3CFONT%20color%3D%22%23FF00FF%22%3Ethree%3C%2FFONT%3E%20tabs%20with%20the%20%3CFONT%20color%3D%22%23FF00FF%22%3Esame%3C%2FFONT%3E%20%3CFONT%20color%3D%22%23FF00FF%22%3Egraph%3C%2FFONT%3E%20except%20different%20information.%20If%20I%20update%20the%20%3CFONT%20color%3D%22%23FF00FF%22%3Efirst%20tabs%3C%2FFONT%3E%20or%20%3CFONT%20color%3D%22%23FF00FF%22%3Eselect%20a%20quarter%3C%2FFONT%3E%20for%20the%20table%20it%20updates%20the%20tables%20in%20tab%20%3CFONT%20color%3D%22%23FF0000%22%3E2%26amp%3B3%3C%2FFONT%3E%20with%20tab%20%3CFONT%20color%3D%22%23FF00FF%22%3E1%3C%2FFONT%3E%20info.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20re-did%20the%20spreadsheet%20and%20now%20it%20is%20giving%20me%20the%20following%20information%20bar%2C%20see%20below.%20Scrnshot%203%3C%2FP%3E%3CP%3EExcel%20found%20one%20or%20more%20formula%20references%20in%20this%20worksheet.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875782%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20spreadsheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875782%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413571%22%20target%3D%22_blank%22%3E%40Vall_Bell1402%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20change%20which%20table%20the%20chart%20is%20looking%20at%20right%20click%20on%20the%20chart%20and%20choose%20Select%20Data%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20665px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133544i374197C4C00F4E89%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethen%20change%20the%20reference%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorclipboard_image_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20413px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133545iDCE841405E4AD1D5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-882309%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20spreadsheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-882309%22%20slang%3D%22en-US%22%3E%3CP%3EI%20understand%20what%20you%20did%20there%20but%20the%20Graph's%20information%20is%20not%20being%20displayed%20accordingly.%20I'll%20keep%20trying%20and%20get%20back%20to%20you%20if%20I%20struggle.%20Thanks%20a%20Mil!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Vall_Bell1402
New Contributor

Good Day All

I was wondering if someone can assist me on how to separate tabs on a spreadsheet. I am currently working on one spreadsheet, I have 3 tabs all exactly the same just the content differs, every time I want view the graph table it only picks up on the first tabs info. I need each tab's graph able to work individually. I'm very new to excel and all it's wonderful uses, please assist me.

 

Kind Regards

 

6 Replies

Hi @Vall_Bell1402

 

So are you saying you have a graph on tab one and you want to replicate that graph onto tab 2 and tab 3 with the data being picked up from those sheets ?

Good day

Thank goodness. That is exactly what I would like to do. So far I have already copy and pasted the table, I need help to convert the right information to all corresponding tabs, and still have the graph working with all SUMS added. The graph also has a filtered select list for 1st Quarter, 2nd Quarter ect. How do I configure the select list to filter each table accordingly?

I hope you understand, thanks a mil for your response!

@Wyn Hopkins 

Hi

It would help if you could post a sample file and or some screenshots to help me understand

Cheers

 

I am very grateful for all your help.

Please see below a screenshot of the Spreadsheet. Keep in mind I have three tabs with the same graph except different information. If I update the first tabs or select a quarter for the table it updates the tables in tab 2&3 with tab 1 info. 

 

I just re-did the spreadsheet and now it is giving me the following information bar, see below. Scrnshot 3

Excel found one or more formula references in this worksheet.

@Wyn Hopkins 

Hi @Vall_Bell1402 

 

To change which table the chart is looking at right click on the chart and choose Select Data

 

image.png

 

 

then change the reference

 

 

image.png

 

 

Highlighted

I understand what you did there but the Graph's information is not being displayed accordingly. I'll keep trying and get back to you if I struggle. Thanks a Mil! @Wyn Hopkins 

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies