Trying to Figure Out a Way to Visualize a Trend for a Large Data Set

[LilyN]

Hello,

I hope someone can help here. I'm trying to figure out a way to visualize a trend of data with five thousands of rows. Each row represents unique value and therefore unique trend.

I've attached the example file.

Thank you,

[MrShorty]

It's not clear to me what you need to do, or what you need help with. Your file shows a handful of columns for specific dates, rows of data that seem related to different id numbers/names.

Visualization usually implies a chart, but I find that most charting questions end up being about arranging or manipulating data. What kind of trends do you want to visualize on this example? Do you need help manipulating or summarizing the data?

[josephteh]

Perhaps, using Sparklines?

[LilyN]

It's not clear to me what you need to do, or what you need help with. Your file shows a handful of columns for specific dates, rows of data that seem related to different id numbers/names.

Visualization usually implies a chart, but I find that most charting questions end up being about arranging or manipulating data. What kind of trends do you want to visualize on this example? Do you need help manipulating or summarizing the data?

I'm trying to create some type of visual to see how data performs over time. Each row is a unique data point that I need to show how each data point performed over time. I have a file with about 5K rows, that's why it's challenging. If it would be 25 rows, I'd just do a line chart.

[MrShorty]

So you are trying to visualize each row as a function of time in the first row. The only reason 5k rows would be problem for a line chart is that it's too much for one chart. Are you looking for a strategy to extract reasonably sized subsets of the data, like a filter? I could see building a chart with all the rows, then use auto filter to show a subset of the data. Would that work, or are you looking for something else?

[LilyN]

So you are trying to visualize each row as a function of time in the first row. The only reason 5k rows would be problem for a line chart is that it's too much for one chart. Are you looking for a strategy to extract reasonably sized subsets of the data, like a filter? I could see building a chart with all the rows, then use auto filter to show a subset of the data. Would that work, or are you looking for something else?

Yes, I'm looking to filter by performance - highlight the lowest/highest performing rows over time.

[MrShorty]

I don't see a field for "performance" in your database. If you added such a field, then a simple auto filter would allow you to filter by performance. https://www.excel-easy.com/data-analysis/filter.html
If you then had a chart based on the full database (unreadable when unfiltered), and your house and empty cells setting was set to hide hiddend data from hidden cells, you should easily be able to filter on performance and see the appropriate data in your line chart.