Home

create a stacked area chart that ignores blank cells

%3CLINGO-SUB%20id%3D%22lingo-sub-865327%22%20slang%3D%22en-US%22%3Ecreate%20a%20stacked%20area%20chart%20that%20ignores%20blank%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-865327%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20very%20large%20data%20set%20that%20examines%20GDP%20per%20capita%20across%20several%20countries%20over%20time.%20I%20would%20like%20to%20compile%20the%20data%20into%20a%20stacked%20area%20graph%2C%20so%20that%20I%20can%20see%20the%20cumulative%20growth%20in%20GDP%20per%20capita.%20However%2C%20the%20data%20contains%20a%20multitude%20of%20blank%20cells%2C%20as%20it%20dates%20back%202000%20years.%20When%20I%20create%20a%20scatter%20plot%2C%20I%20can%20ignore%20blank%20cells%20and%20connect%20points%20directly%20using%20the%20%22hidden%20%26amp%3B%20empty%20cells%22%20button.%20When%20I%20attempt%20to%20plot%20as%20a%20stacked%20graph%2C%20the%20option%20is%20not%20available.%26nbsp%3B%20I%20have%20attached%20a%20small%20example%20from%20within%20my%20data%20that%20shows%20the%20same%20data%20plotted%20as%20a%20scatter%20plot%2C%20and%20as%20stacked%20area.%3C%2FP%3E%3CP%3EBecause%20the%20data%20includes%20200%20columns%2C%20and%20varied%20blanks%20throughout%2C%20I%20would%20like%20to%20find%20an%20efficient%20way%20to%20create%20linear%20progression%20between%20two%20filled%20cells%2C%20so%20that%20I%20can%20accurately%20measure%20a%20total%20GDP%20per%20capita.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-865327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
cjdataartist
Occasional Visitor

I have a very large data set that examines GDP per capita across several countries over time. I would like to compile the data into a stacked area graph, so that I can see the cumulative growth in GDP per capita. However, the data contains a multitude of blank cells, as it dates back 2000 years. When I create a scatter plot, I can ignore blank cells and connect points directly using the "hidden & empty cells" button. When I attempt to plot as a stacked graph, the option is not available.  I have attached a small example from within my data that shows the same data plotted as a scatter plot, and as stacked area.

Because the data includes 200 columns, and varied blanks throughout, I would like to find an efficient way to create linear progression between two filled cells, so that I can accurately measure a total GDP per capita.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies