Linear Chart

Hi Gurus,

Good morning, i just want to ask you , what would be the idea and the approach to create this type of chart

http://geocities.com/goma_23/chartsample1.jpg

Data composed of the following :

http://geocities.com/goma_23/data1.jpg

The design is to create a chart on a specific range of dates, and see the movements, the last column on data are percentage, I have little idea about chart but only on X & Y axis only , but never on having 3 ingredients.

Hope you could help me on this one.

Kind Regards,
Goma23

thanks oldchippy, this is what i did :

1. convert/pivot the table
2. from the pivoted table , created a chart, and from there i played with the settings until i got what it want,

But my newest problems is if in case there will be no data on specific date and time, it will post as 0% thus the graph will be shown downward, is there a way to suppress zero? (technically it is not included in the data, but since it is a pivoted table, there is a tendency since not all data will have the same instance , for example day1 has 3 instance , day2 has 4 instance, on the pivot table , day1 on it's 4th instance will be zero.


Regards,

Thanks oldchippy , i really appreciate your help!