Ask Your Question

How to make a stacked column chart based on this data? [closed]

asked 2013-09-29 22:42:24 +0100

IanSan5653 gravatar image

updated 2020-08-02 17:11:28 +0100

Alex Kemp gravatar image

I have survey data in Calc like this (only with 295 rows, columns to AO, and 6 options):

Graph Data

and I want to make a chart like this:


However, when I select the data and create a chart, I get this:


Obviously I am doing something wrong, but I can't figure out how to make this work. I definitely don't want to redo the entire sheet.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 13:37:51.395951

1 Answer

Sort by » oldest newest most voted

answered 2013-09-30 00:46:35 +0100

m.a.riosv gravatar image

Please see if the attached file solves what you want get.

Making an intermediate table with the count for every data in every item and with this new table making the graphics with data in rows.


(The true extension for the file is ods, but there is a bug in the site and only files with graphics extension are allowed)

edit flag offensive delete link more


Is there an easy way to make this count? I have a lot of data, so there is no way I can count it.

IanSan5653 gravatar imageIanSan5653 ( 2013-09-30 03:37:16 +0100 )edit

When do you say a lot of data, you are talking about "items", "ABCD" or number of rows.

m.a.riosv gravatar imagem.a.riosv ( 2013-09-30 23:57:11 +0100 )edit

Question Tools

1 follower


Asked: 2013-09-29 22:42:24 +0100

Seen: 2,611 times

Last updated: Jan 08 '14