I have scatterplots with date/time along the X axis, and data on the Y axis.
I'd like to add shading from sunrise to sunset.
I can create a line on the scatterplot that is 0 during the day and a value
greater than the max Y value at night, but would like to be able to shade
under this line to more easily visualize when it's dark.
I also tried creating a bar graph in the background on a second X axis,
thinking I could have small categories with date and light/dark data, but the
time axis cannot do increments smaller than days, so that hasn't worked.
Any suggestions? I have hundreds of these graphs that I'd like to add this
data to.
Thanks
Jon Peltier - 04 Nov 2006 00:07 GMT
Try something like this:
http://peltiertech.com/Excel/Charts/XYAreaChart.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
>I have scatterplots with date/time along the X axis, and data on the Y
>axis.
[quoted text clipped - 15 lines]
>
> Thanks