Excel 2007 charts

[iswarialakshmi]

I want to draw chart for multiple values like


1-Dec------------------------------------31 Dec

hour pro 1 pro 2 pro 3

1 1 2 6

2 3 5 7

3 0 9 8

4 2 8 6

5 0 5 3

. . . .

. . . .

.

For whole month

 

[Luke M]

Are you wanting to plot 1 day and show progression by hr, 1 hr and show progression by day, or progression for each hr of each day?


If the last case, I would think you'd need to re-arrange the data to form a very long x-y scatter plot, with your x-axis being a time series incrementing by 1 hr.


The former two could more easily be accomplished, and could be made as dynamic charts (Chandoo and www.peltiertech.com both have good examples of how to do this)

 

[iswarialakshmi]

i want data to be plotted in a single chart for all days and a hours.How about 3 dimensional chart?