1

I have a gaming log on a Google Sheets document and I was trying to add tags for the "genre" column but couldn't find any option myself.

Basically I'd like to make it so that the entries "RPG; FPS; Open-World" under the "Genre" would be separate words and not a single word, in order to make a detailed pie-chart of my most played genres. I know, kinda stupid, but I'd love it. Otherwise every game would have a different genre and the pie-chart would just show useless data.

Here's my log on Sheets:

Log

Unfortunately I couldn't really find much. I read something along the lines of creating a form (why?) and use it to add user-defined tags. I have no idea how that could help me. I also had a look in here but I only found formulas I had no idea how to "adapt" to my case.

2
  • Welcome. Please add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Mar 15 '20 at 1:15
  • Added! Sorry for that. – jaKz9 Mar 15 '20 at 9:43
0

From the question:

Basically I'd like to make it so that the entries "RPG; FPS; Open-World" under the "Genre" would be separate words and not a single word, in order to make a detailed pie-chart of my most played genres.

Tl;Dr That is not possible in Google Sheets and in most of the spreadsheet applications. Perhaps this could be possible in EtherCalc

In most spreadsheet apps a single cell can hold a single value, not multiple values. This is one of the core features of a spreadsheet but that doesn't mean that you can't use your data to create a pie chart as you could transform your data to the structure required by a pie chart by using formulas, Google Apps Script or the Sheets API.


From Wikipedia

Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

From the Sheets API docs

A cell is a location at the intersection of a particular row and column, and may contain a data value.

References

3
  • Thanks for pointing this out. Do you have any other idea how I could achieve a similar result by taking advantage of Sheets' features? Or should I just resort to a single word for my genre column? – jaKz9 Mar 15 '20 at 20:34
  • @jaKz9 If your goal is to create a pie chart, ask how to create it. In your question include a link to a demo spreadsheet with sample data. – Rubén Mar 15 '20 at 23:55
  • No, sorry, I do know how to create it. I was just asking if you had any "workaround" the achieve the same result, without using tags. It seems it can't be done though, so thanks anyway. – jaKz9 Mar 16 '20 at 12:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.