Ask Your Question
0

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

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

IanSan5653 gravatar image

updated 2014-01-08 01:14:10 +0200

oweng 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:

Graph

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

Graph

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
1

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

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.

StackedBars_RecalcData.jpg

(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

Comments

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 +0200 )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 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 2,339 times

Last updated: Jan 08 '14