Question I have a chart I'd like to generate but I have no idea how to do it

[aarad]

Hey,

I'm looking to generate a ranking list in a similar form to a horizontal bar chart in the following format:
(https://i.postimg.cc/XqM4mpFh/CHART-mock-up.jpg)





...and I'm hoping somebody knows the best way and which software to use to make it happen. (Apologies if the picture link above doesn't work.)

Here are the details:

I've collected data of 60 works of art where 20 people could rate them in points from -3 through to 3.

I'd like to display the information in ranking list in the following way:

1. The works of art are the items being ranked, they are represented by a thumbnail rather than text.

2. Each item displays three types of data: the positive points, negative points and total points all as horizontal bars, the items on the ranking list can also be sorted according to all three of these data types.

3. It should be possible to update the information any time.

I did find an online chart generator here:

https://www.chartle.com/#horizontalBar

..which is quite flexible in that it allows me to update the data any time but it doesn't offer anything else I need, such as a way to sort the items or list the thumbnails in the axis.

If anybody knows how to tackle this problem I'd love to hear your suggestions, I unfortunately have very little knowledge of coding so despite knowing exactly what I want I have no idea how to make it lol.

Thanks in advance

 

[Grobe]

Have you considered using a spread sheet for doing that - like Libre Office Calc or MS Excel ?

 

[USAFRet]

Yep, this is exactly what a spreadsheet is for.
Adding to the above 2 choices, Google Sheets

Google Sheets: Onlinetabellen und Vorlagen | Google Workspace

Mit Google Sheets Onlinetabellen erstellen, in Echtzeit von überall aus zusammenarbeiten und künstliche Intelligenz unter anderem für Analysen nutzen – jetzt loslegen.

www.google.com

 

[aarad]

Actually I did try Google sheets, I was unable to figure out how to add horizontal bar charts as data points I couldn't find a tutorial, I assumed Excel and Calc would be the same but I realise they're more popular options with more support. I try your suggestions and see what happens, thank you.

 

[USAFRet]

Actually I did try Google sheets, I was unable to figure out how to add horizontal bar charts as data points I couldn't find a tutorial, I assumed Excel and Calc would be the same but I realise they're more popular options with more support. I try your suggestions and see what happens, thank you.

All very customizable.


Excel

LibreOffice Calc

GoogleSheets

 

[aarad]

All very customizable.


Excel

LibreOffice Calc

GoogleSheets

See the issue I found is I wanted to have a bar chart for each data point that you could interact with by sorting so this sheets charts function only gives me one of the three things I needed. Thanks though.

 

[aarad]

Just an update for people experiencing a similar issue, I tried Calc as well which didn't allow me to insert pictures inside cells so they follow the cells when sorted, Sheets did actually allow that but doesn't have intractable inside-cell charts that would have any effect on the sorting either. I fear it's going to have to be a case of learning to code an building it from scratch.

 

[USAFRet]

See the issue I found is I wanted to have a bar chart for each data point that you could interact with by sorting so this sheets charts function only gives me one of the three things I needed. Thanks though.

I'm quite certain that any of those 3 tools can do exactly what you want.
Just takes a bit of investigation and learning.

 

[Grobe]

I tried Calc as well which didn't allow me to insert pictures inside cells so they follow the cells when sorted

That is strange, I tested this and I get Calc to move images as well, both on sorting or any other operation that shift cell position. Check if the image is set to be anchored to cell. It should work.