OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Google Sheets - wykres dynamiczny?

  • Thread starter Thread starter Marcin Ogiński
  • Start date Start date
M

Marcin Ogiński

Guest
Well, I have a survey with customer responses, of course in Google sheets. My task is to make it relatively simple to be able to check how many people who, for example, answered 5 (on a scale of 1-5) to the question in column 3, what answers they chose in question no. 15 or another. It would be best to create a chart for this so that team members know.
I created a chart, but it works as long as it is marked answer filtering 5, when I remove the filter it disappears.

I will be grateful for a hint, because here I probably need to use some command or use data validation.

Otóż, mam ankietę z odpowiedziami klientów, oczywiście w google sheets. Moim zadaniem jest obrobić to w miarę prosto, by móc sprawdzić ile osób, które np. odpowiedziało 5 (w skali 1-5) na pytanie w kolumnie 3, jakie odpowiedzi wybrało w pytaniu nr 15 lub innym. Najlepiej byłoby stworzyć do tego wykres, by członkowie zespołu wiedzieli.
Stworzyłem wykres, jednak on działa dopóki jest oznaczone filtrowanie odpowiedzi 5, kiedy usuwam filtr, to znika.

Będę wdzięczny za podpowiedź, bo tu pewnie trzeba zastosować jakąś komendę bądź wykorzystać sprawdzanie poprawności danych.

I tried to create a dynamic chart based on data validation, but this solution did not work because the answers were selected from several options. The regular chart didn't work because as long as I had filtering set, everything was fine, when I removed it, the chart disappeared.

Continue reading...
 

Latest posts

D
Replies
0
Views
1
Domantas Giedraitis
D
S
Replies
0
Views
1
Srikanta saw
S
Top