There is a whole industry devoted to data visualization and many books written about it and for good reasons. I would not have thought not many people can do it from a spreadsheet but data presented as a graph, chart or pictogram makes it easier to analyze, to spot trends and patterns.
There are hundreds of website data visualization tools around. I happen to like the Google Charts API, sometimes known as the Google Visualization API, and these pages were written to answer some common questions about using the API and to give solutions to problems I have encountered when using it.
The API can be found at https://developers.google.com/chart. The documentation is usually very good with plenty of examples.
The API has its own user-supported forum or group at https://groups.google.com/g/google-visualization-api. A general Google query including "Google Chart" or "Google Visualization" (including the quotes) will generally bring up several results usually from Stack Overflow.
Using Google Sheets as a data source
Get and set data in a datatable
Multiple Charts on a Page
Tables: Adding Links
Tables: Tooltips & Popups
Tables: Using Dates