[Solved] Creating a chart that has data in columns

[soaring_eagle]

I'm using XFCE version 4.12 and Calc version: 5.1.4.2.

I would like to create a pie chart that has data in columns, not in rows, like below. Is it possible? Ideally the part in bold (How have you read them?) would be the title.

How have you read them?
I have read them as part of an email:
7
I have sometimes used the emails and sometimes used the booklet.
2
I have used the booklet to know which passages to read
0

I would also like to create a pie chart with the no responses as red and yes responses as green, maybe automatically, but I think this is getting ahead of myself.

Thanks!
Naomi

[jrkrideau]

I'm using XFCE version 4.12 and Calc version: 5.1.4.2.

I would like to create a pie chart that has data in columns, not in rows, like below. Is it possible? Ideally the part in bold (How have you read them?) would be the title.

How have you read them?
I have read them as part of an email:
7
I have sometimes used the emails and sometimes used the booklet.
2
I have used the booklet to know which passages to read
0

I would also like to create a pie chart with the no responses as red and yes responses as green, maybe automatically, but I think this is getting ahead of myself.

Thanks!
Naomi

Sorry Naomi, but I don't understand what you want. Normally you would have the data in two columns, Labels in the left-most, numerics in the right.

Code: Select all

I have read them as part of an email:  7
I have sometimes used the emails and sometimes used the booklet.  2

and so on.

What is the different layout that you want? Or am I misunderstanding your data?

I would also like to create a pie chart with the no responses as red and yes responses as green, maybe automatically, but I think this is getting ahead of myself.

Well this is easy enough but probably redundant. Just say it in text: Something like we received 70 yes responses and 11 no. Unless you need the glitz a two part pie chart probably is not going to provide a lot of information though I suppose in some cases it might provide a useful bit of shock value.

[soaring_eagle]

What is the different layout that you want? Or am I misunderstanding your data?

Yes, I normally would set up my data in that way, but information has been given to me with the label above then the numbers in the next row down! I've added an attachment to explain. I thought it might be easier to learn how to do the chart in a different way, rather than end up copying and pasting information a lot!

Well this is easy enough but probably redundant. Just say it in text: Something like we received 70 yes responses and 11 no. Unless you need the glitz a two part pie chart probably is not going to provide a lot of information though I suppose in some cases it might provide a useful bit of shock value.

I agree that the text is probably easier and more straightforward, but again I thought I should learn how to do it, and yes, the shock value might be good!

Thanks,
Naomi

[MrProgrammer]

I thought it might be easier to learn how to do the chart in a different way …

If you want Calc to make the chart you'll need to arrange the data as the software expects, not as a table with alternating question/answer rows. Read about creating charts in Help → Index or in User Guides (PDF) or searching for topics about them in the Calc Forum.

… rather than end up copying and pasting information a lot!

[Tutorial] Rearrange rectangular data values

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[soaring_eagle]

Fab. Thanks!