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 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.
These examples are used on live website pages:
Eclipse Foundation LocationTech Activity
Favourites on the Free Music Archive
HMS Gambia crewlist
Sea-level Data Analysis and Visualization - Most of the charts are drawn with PHP and so the source is hidden, but some charts such as Atmospheric Carbon Dioxide (CO2) Levels, 1800–present are not and the script used to create them is viewable by looking at the source code.
Valences of characters and institutions in newspapers
Using Google Sheets as a data source
Get and set data in a datatable
CSV file as data source
Multiple Axes in a chart
Saving a Chart as an Image
Multiple Charts on a Page
Tables: Adding Links
Tables: Tooltips & Popups
Tables: Using Dates