Visualising 5k+ time series within a Pivot Table/Chart dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-1432879%22%20slang%3D%22en-US%22%3EVisualising%205k%2B%20time%20series%20within%20a%20Pivot%20Table%2FChart%20dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi!%20I%20need%20to%20visualise%205k%2B%20times%20series%20(rows)%204%20years%20monthly%20sales%20data%20(columns).%20What%20is%20the%20best%20way%20to%20do%20it%3F%20I%20use%20Pivot%20Table%20and%20Pivot%20Chart%20but%20cannot%20add%20trend%20line%20and%20equation%20with%20R-square%20ratio%2C%20also%20cannot%20change%20bar%20chart%20into%20line%20chart.%20Cannot%20add%20time%20stamp%20to%20the%20data.%20Please%20notice%20times%20series%20are%20in%20rows%2C%20not%20in%20columns%20as%20number%20of%20products%20increase%205k%2B.%20Each%20product%20has%20to%20analysed%26nbsp%3Bseparately.%26nbsp%3B%20Any%20hints%3F%20Kind%20regards%2C%20Luke%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1432879%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
Highlighted
Occasional Visitor

Hi! I need to visualise 5k+ times series (rows) 4 years monthly sales data (columns). What is the best way to do it? I use Pivot Table and Pivot Chart but cannot add trend line and equation with R-square ratio, also cannot change bar chart into line chart. Cannot add time stamp to the data. Please notice times series are in rows, not in columns as number of products increase 5k+. Each product has to analysed separately.  Any hints? Kind regards, Luke

0 Replies