Edit Table Data from another worksheet on iPad

%3CLINGO-SUB%20id%3D%22lingo-sub-1247146%22%20slang%3D%22de-DE%22%3EEdit%20Table%20Data%20from%20another%20worksheet%20on%20iPad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247146%22%20slang%3D%22de-DE%22%3E%3CP%3EDear%20community%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20healthy!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20quick%20question%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20say%20I%20hava%20data%20in%20Sheet%201.%20(a1)%26nbsp%3B%3CSPAN%3Ebut%20the%20corresponding%20Graphic%20Chart%20on%20Sheet%202%20(so%20showing%20the%20data%20in%20a1).%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAfter%20one%20week%20I%20add%20more%20data%20in%20Sheet%201%20(a1%20and%20a2).%20So%20I%20need%20to%20tell%20the%20Graph%20in%20Sheet%202%20that%20it%20should%20include%20row%202%20in%20the%20graph.%20On%20the%20pc%20I%20can%20easily%20do%20that.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20that%20I%20can%20adjust%20the%20data%20referrence%20on%20the%20iPad%20or%20does%20the%20Graph%20need%20to%20be%20in%20the%20same%20sheet%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1247146%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Dear community

 

I hope you are healthy!

 

I have a quick question:

 

Let‘s say I hava data in Sheet 1. (a1) but the corresponding Graphic Chart on Sheet 2 (also showing the data in a1). 

After one week I add more data in Sheet 1 (a1 and a2). So I need to tell the Graph in Sheet 2 that it should include row 2 in the graph. On the pc I can easily do that. 

 

Is there a way that I can adjust the data referrence on the iPad or does the Graph need to be in the same sheet? 

 

Thanks for your reply.

0 Replies