How could i higlight different intervals in the charts. e.g. I have on the
horizental axis time from 0 hrs to 24 hrs. and on the vertical axis body
temprature. I have three different subjects data on this chart. I would like
to higlight the area where those subjects were sleeping, but I could't get
the solution in MS Excel. Does anyone helps me on this issue

Hi,

You could add another series plotted as column. Plotting the maximum value
when shading is required.
You will need to set the maximum Y axis value so the columns can reach the
top of the plot area.

Format the columns via the Series Options tab on the Format dialog to have a
gap width of zero.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Munir" wrote in message
...
How could i higlight different intervals in the charts. e.g. I have on the
horizental axis time from 0 hrs to 24 hrs. and on the vertical axis body
temprature. I have three different subjects data on this chart. I would
like
to higlight the area where those subjects were sleeping, but I could't get
the solution in MS Excel. Does anyone helps me on this issue