Hello.
Well, I posted this somewhere at Naver.com, which is a very popular search portal in South Korea the other day. (I am Korean.)
I am not getting any answer yet.
I would greatly appreciate it if somebody can help me out.
Partial answers will also be highly appreciated if you don't know all of them.
(I spent more than 2.5 hours to post this. Drawing a graph and two tables is killing me. lol)
(I used white colored underscores to put some space in the table and graph.)
Here are two tables. (P stands for person.)
[Table1] - When high calrorie foods consumed (grams)
___Date__________P1_______P2_______P3_______P4_______P5
11-10-2011 _____+100____ +300_____+300______ 0 ______+500
11-09-2011 _____+530____ +663_____+232_____ +343 ____+242
11-08-2011 _____+360____ +443_____+321_____ +527 ____+415
[Table2] - When low calrorie foods consumed(grams)
___Date__________P1_______P2_______P3_______P4_______P5
11-10-2011 _____-300_____ -200_____-500____ -500 _____-100
11-09-2011 _____-530_____ -993_____-841______ 0 ______-321
11-08-2011 _____-332_______ 0 _____ -535 ___ -253 _____-332
Basically Table 1 and Table 2 show the chages in each one's weight measured at a particular time during a day.
Table 1 shows when each one had high calorie foods while Table 2 low calrorie foods.
[Question 1]
Let's assume that the volume of each box(■) shows 100 grams.
The red box indicates the increased portion, the blue one represents the decreased amount, the green one is the sum of the red and the blue.
It doesn't have to be those colors - red, blue and green. It's OK as long as they can be easily identifiable by any colors or patterns.
How can I draw a graph like this?
____ ____ ____ ______p1____ p2____ p3 ____ p4 ____ p5
______________500 ______________________________■
______________400 ______________________________■
______________300__________■______■_____________■
______________200__________■______■_____________■
______________100 ___■_____■______■______________■
_[2011-11-10]__ 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
_____________-100 ___■_____■______■_______■______■
_____________-200 ___■_____■______■_______■
_____________-300 ___■____________■_______■
_____________-400_________________■_______■
_____________-500_________________■_______■
[Question 2] I think the questions are pretty tough.
a) If I put the data in those two tables, I want the excel to automatically generate the graph for each date on each sheet. How can I do this?
b) I want to have a small calendar, so that I can choose a specific date to get a graph on that date. How can I do this? ( I guess this is the most difficult question...)
c) I want to display a year, month, and date like this -> ◀ 2011-11-10 ▶
Right arrow(▶) for the next date while left arrow(◀) for the previous date. If I choose a specific date, I want to get a graph for that date. What do I have to do?
[Question 3]
Is there any way I can see the green boxes only in the graph by clicking any button or whatever?
Well, I posted this somewhere at Naver.com, which is a very popular search portal in South Korea the other day. (I am Korean.)
I am not getting any answer yet.
I would greatly appreciate it if somebody can help me out.
Partial answers will also be highly appreciated if you don't know all of them.
(I spent more than 2.5 hours to post this. Drawing a graph and two tables is killing me. lol)
(I used white colored underscores to put some space in the table and graph.)
Here are two tables. (P stands for person.)
[Table1] - When high calrorie foods consumed (grams)
___Date__________P1_______P2_______P3_______P4_______P5
11-10-2011 _____+100____ +300_____+300______ 0 ______+500
11-09-2011 _____+530____ +663_____+232_____ +343 ____+242
11-08-2011 _____+360____ +443_____+321_____ +527 ____+415
[Table2] - When low calrorie foods consumed(grams)
___Date__________P1_______P2_______P3_______P4_______P5
11-10-2011 _____-300_____ -200_____-500____ -500 _____-100
11-09-2011 _____-530_____ -993_____-841______ 0 ______-321
11-08-2011 _____-332_______ 0 _____ -535 ___ -253 _____-332
Basically Table 1 and Table 2 show the chages in each one's weight measured at a particular time during a day.
Table 1 shows when each one had high calorie foods while Table 2 low calrorie foods.
[Question 1]
Let's assume that the volume of each box(■) shows 100 grams.
The red box indicates the increased portion, the blue one represents the decreased amount, the green one is the sum of the red and the blue.
It doesn't have to be those colors - red, blue and green. It's OK as long as they can be easily identifiable by any colors or patterns.
How can I draw a graph like this?
____ ____ ____ ______p1____ p2____ p3 ____ p4 ____ p5
______________500 ______________________________■
______________400 ______________________________■
______________300__________■______■_____________■
______________200__________■______■_____________■
______________100 ___■_____■______■______________■
_[2011-11-10]__ 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
_____________-100 ___■_____■______■_______■______■
_____________-200 ___■_____■______■_______■
_____________-300 ___■____________■_______■
_____________-400_________________■_______■
_____________-500_________________■_______■
[Question 2] I think the questions are pretty tough.
a) If I put the data in those two tables, I want the excel to automatically generate the graph for each date on each sheet. How can I do this?
b) I want to have a small calendar, so that I can choose a specific date to get a graph on that date. How can I do this? ( I guess this is the most difficult question...)
c) I want to display a year, month, and date like this -> ◀ 2011-11-10 ▶
Right arrow(▶) for the next date while left arrow(◀) for the previous date. If I choose a specific date, I want to get a graph for that date. What do I have to do?
[Question 3]
Is there any way I can see the green boxes only in the graph by clicking any button or whatever?
Last edited: