Thread: Shading
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Cow Girl Cow Girl is offline
external usenet poster
 
Posts: 12
Default Shading

I'm stumped. I've looked at 2 different sites
(http://peltiertech.com/Excel/Charts/XYAreaChart2.html and
http://www.andypope.info/ngs/ng21.htm) to figure out how to shade, but I'm
missing something here.

My data covers monthly figures Jan - Dec. There is a max and min for each
month. I want to shade between those 2 points and then plot the current
year's figures over that range.

In looking at both of the sites above, it seems like Jan - Dec need to be
numbers. So, I know I'm missing some little step, I just don't know what it
is.

Thanks!