Multiple data in one column
Closed
diestra123
Posts
9
Registration date
Monday 22 October 2012
Status
Member
Last seen
15 July 2013
-
6 Nov 2012 à 05:19
diestra123 - 7 Nov 2012 à 11:04
diestra123 - 7 Nov 2012 à 11:04
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.
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.
Related:
- Multiple data in one column
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- How to lasso multiple objects in photoshop - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Gta 5 data download for pc - Download - Action and adventure
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Moderator
Last seen
27 December 2022
555
6 Nov 2012 à 08:55
6 Nov 2012 à 08:55
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
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
Zohaib R
Posts
2368
Registration date
Sunday 23 September 2012
Status
Member
Last seen
13 December 2018
69
6 Nov 2012 à 17:02
6 Nov 2012 à 17:02
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.
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.
