How could i higlight different intervals in the charts

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
 
A

Andy Pope

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

Superimposing Charts 2
Setting x axis scale to time with variable intervals 1
Merging 3 Charts into 1 9
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
How do I change only part of the background in a chart Excel 07 2
Changing the Y axis on a column chart 1
Same Value Axis Numbers in Four Charts 1
data labels in charts 1

Top