Area highlight in excel chart

[mkengel]

I have data of the following format
X: year/month/day
Y: value
Y2: value2

I want to highlight the area from Y to Y+0.5 for all X, using the Y
scale

How could I do this in Excel 2003 ?

Thank you
Michael

apparently my first post got lost in ???

 

[Jon Peltier]

Could you use something like this:

http://peltiertech.com/Excel/Charts/XYAreaChart2.html

- Jon

 

[mkengel]

Could you use something like this:
http://peltiertech.com/Excel/Charts/XYAreaChart2.html

Thanks Jon for the link. Actually, I saw this link before but I failed
to get the results, I want. E.g. if I fill between the lines, the
helplines through the chart vanished and also the marked area doesn't
cover the full scale (X-axis), and, and...

When I see what efforts are necessary to make such a simple task, I
think that Excel charts are still stone-age tools (don't know if
competitors are better or worse).
I should be much easier to do such tasks without even using your
clever work-arounds.

I would expect from Excel to be able to treat parts of the charts
differently from others (like the tags of the axes, background, just
to name two) and to set this all from a single window "chart
properties".

Michael