Home

Dynamic graph range

%3CLINGO-SUB%20id%3D%22lingo-sub-711052%22%20slang%3D%22en-US%22%3EDynamic%20graph%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711052%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20graph%20with%20a%20dynamic%20X-axis.%20Basically%20to%20see%20to%20see%20how%20much%20sales%20we%20obtain%20x%20days%20in%20advance%20until%20a%20random%20date.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20X-axis%20adaptation%20works%20perfectly.%20I%20am%20using%20a%20%3DINDEX()%3AINDEX()%20formula%20to%20find%20the%20dates%20I%20am%20looking%20for%20and%20create%20a%20range%20for%20the%20graph%20to%20use.%20Unfortunately%2C%20when%20I%20change%20my%20x%20axis%2C%20the%20data%20itself%20does%20not%20change%20along%20with%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EDue%20to%20confidentiality%20I%20am%20a%20bit%20bound%20by%20what%20I%20can%20share%20but%20I%20added%20two%20pictures%20that%20show%20my%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKey%20is%20to%20not%20that%20the%20graph%20uses%204%20data%20sources%20all%20based%20on%20the%20same%20date%20range!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20or%20creativity%20is%20much%20appreciated!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-711052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
160098
New Contributor

Hi guys,

 

I have created a graph with a dynamic X-axis. Basically to see to see how much sales we obtain x days in advance until a random date. 

 

The X-axis adaptation works perfectly. I am using a =INDEX():INDEX() formula to find the dates I am looking for and create a range for the graph to use. Unfortunately, when I change my x axis, the data itself does not change along with it. 

Due to confidentiality I am a bit bound by what I can share but I added two pictures that show my issue. 

 

Key is to not that the graph uses 4 data sources all based on the same date range!

 

Any help or creativity is much appreciated!!

Related Conversations