How could i higlight different intervals in the charts

  • Thread starter Thread starter Munir
  • Start date Start date
M

Munir

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
 
Back
Top