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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

time scale proportional using a column chart - not just for scatte 4
Chart doesn't recognize date format 4
Changing an axis to show time with hour intervals 3
Horizontal Axis Options Changing 6
How do I change only part of the background in a chart Excel 07 2
Changing the Y axis on a column chart 1
Superimposing Charts 2
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2

Back
Top