SOLVED

Axis Alignment

%3CLINGO-SUB%20id%3D%22lingo-sub-3301164%22%20slang%3D%22en-US%22%3EAxis%20Alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301164%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20an%20example%20file%20of%20what%20I%20am%20trying%20to%20achieve.%20Tab%201%20shows%20how%20my%20data%20is%20currently%20aligned%20along%20with%20a%20graph%20which%20I%20want%20to%20use.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETab%202%20shows%20a%20different%20design%20of%20the%20data%20and%20graph%2C%20which%20I%20also%20want%20to%20use%20but%20wondered%20if%20this%20%3CSTRONG%3Egraph%3C%2FSTRONG%3E%20could%20be%20achieved%20%3CSTRONG%3Eusing%20the%20data%20structured%3C%2FSTRONG%3E%26nbsp%3Bwithin%20Tab%201%3F%20I've%20done%20some%20Googling%2C%20but%20couldn't%20find%20a%20solution%20so%20thought%20it%20would%20be%20worth%20seeing%20if%20anyone%20can%20validate%20whether%20or%20not%20this%20can%20be%20achieved!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3301164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302283%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20Alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20color%3D%22%232356EF%22%3E%3CU%3E%40%3CA%20href%3D%22https%3A%2F%2Fwww.businessstudynotes.com%2Ffinance%2Fproject-management%2Fslack-time-formula-calculation%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EPeter%20Bartholomew%3C%2FA%3E%3C%2FU%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20Really%20appreciate%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302276%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20Alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302276%22%20slang%3D%22en-US%22%3EThanks%20Hans%20for%20the%20response%2C%20I've%20since%20altered%20the%20approach%20to%20avoid%20creating%20a%20lengthily%20process.%20I%20initially%20wasn't%20sure%20if%20there%20was%20a%20function%20within%20excel%20which%20I%20missed%20and%20could%20support.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302274%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20Alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302274%22%20slang%3D%22en-US%22%3EThanks%20Peter%20for%20the%20response%2C%20I've%20since%20altered%20the%20approach%20to%20avoid%20creating%20a%20lengthily%20process.%20I%20initially%20wasn't%20sure%20if%20there%20was%20a%20function%20within%20excel%20which%20I%20missed%20and%20could%20support.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3301255%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20Alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301255%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1322017%22%20target%3D%22_blank%22%3E%40E_D123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20key%20to%20this%20might%20be%20the%20fact%20that%20the%20chart%20calculation%20engine%20does%20not%20require%20range%20references%3B%20it%20will%20also%20accept%20named%20arrays.%26nbsp%3B%20I%20would%20need%20to%20remind%20myself%20whether%20'%3CSTRONG%3ETab%201'!Series1%3C%2FSTRONG%3E%20is%20a%20legal%20name%20for%20a%20chart%20series%20or%20whether%20something%20else%20needs%20to%20be%20dreamt%20up.%26nbsp%3B%20The%20presentation%20of%20the%20data%20restructuring%20will%20also%20appear%20rather%20different%20in%20365%20and%20legacy%20Excel.%26nbsp%3B%20Something%20else%20that%20I%20have%20never%20tried%2C%20is%20to%20enter%20a%202D%20array%20rather%20than%20individual%20series%3B%20it%20may%20work%20but%20I%20wouldn't%20be%20too%20hopeful%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3301187%22%20slang%3D%22en-US%22%3ERe%3A%20Axis%20Alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1322017%22%20target%3D%22_blank%22%3E%40E_D123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20far%20as%20I%20know%2C%20you%20do%20have%20to%20use%20the%20data%20layout%20as%20on%20Tab%202%3B%20you%20won't%20get%20that%20chart%20using%20the%20daya%20layout%20of%20Tab%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi there,

 

I've attached an example file of what I am trying to achieve. Tab 1 shows how my data is currently aligned along with a graph which I want to use. 

 

Tab 2 shows a different design of the data and graph, which I also want to use but wondered if this graph could be achieved using the data structured within Tab 1? I've done some Googling, but couldn't find a solution so thought it would be worth seeing if anyone can validate whether or not this can be achieved!

 

Thank you!

5 Replies

@E_D123 

As far as I know, you do have to use the data layout as on Tab 2; you won't get that chart using the daya layout of Tab 1.

best response confirmed by E_D123 (Occasional Contributor)
Solution

@E_D123 

The key to this might be the fact that the chart calculation engine does not require range references; it will also accept named arrays.  I would need to remind myself whether 'Tab 1'!Series1 is a legal name for a chart series or whether something else needs to be dreamt up.  The presentation of the data restructuring will also appear rather different in 365 and legacy Excel.  Something else that I have never tried, is to enter a 2D array rather than individual series; it may work but I wouldn't be too hopeful there.

Thanks Peter for the response, I've since altered the approach to avoid creating a lengthily process. I initially wasn't sure if there was a function within excel which I missed and could support.
Thanks Hans for the response, I've since altered the approach to avoid creating a lengthily process. I initially wasn't sure if there was a function within excel which I missed and could support.

@Peter Bartholomew

 

Yes Really appreciate it.