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

Excel 2010 - Line Chart with Mulitiple Data Sets 1
How do I make x-axis dates in area chart not start from/drop to ze 5
How do I change only part of the background in a chart Excel 07 2
Excel basic chart data layout 1
How to get multiple lines on one graph 2
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Problem with scatter chart 1
Employee Schedule not plotting properly - chart type / data series not correct 0

Top