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%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%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
Tabs and Dark Mode
cjc2112 in Discussions on
38 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