Area highlight in excel chart
 

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 ???

Area highlight in excel chart
 

Could you use something like this:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mkengel" wrote in message
oups.com...
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 ???

Area highlight in excel chart
 

On Oct 25, 1:24 am, "Jon Peltier"
wrote:
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