Multiple data in one column

[Closed]
Report
Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013
-
 diestra123 -
Hello,

How do I plot multiple data in one column?

Example: I submitted 10 for today. So my column chart will show a column with a value of 10 for today. And when these inspections are returned to me, they will either be approved or rejected. Say 6 are approved and 4 are rejected. I want them to appear in the next column as one , colored differently, so it will be easily seen that all the inspections submitted for that day have been returned with their respective status.

Thanks...any help would be appreciated.


2 replies

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Diestra,

What do you mean by: "I want them to appear in the next column as one"?

When I take this literary, then type 6 space 4 into a cell, select 6 give color, select 4 give different color.

Why not use two columns for that?

Best regards,
Trowa
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
Hi diestra123,

From your post I understand that you want two types of chart to be displayed on a single graph. The first one should be a column chart with the totals and the other should be stack chart with the list of rejected and accepted. There is a trick involved in doing this. Go through the below mentioned YouTube Video for the tutorial:

https://www.youtube.com/watch?v=j8kMp5IC6oE

I hope you will find this useful. If you need further clarification do reply with sample data.

thanks zohaib R! problem solved! :)