Thread: Shading
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Ed Ferrero[_3_] Ed Ferrero[_3_] is offline
external usenet poster
 
Posts: 108
Default Shading

Not too sure what you want to do, but;
Enter the months as a full date - ie enter 1/12/08 for Dec 2008, 1/1/09 for
Jan 09 etc
Format the cells to show month - use a custom format like mmm or mmmm or
mmm/yy
Now the cells containing the months are date serial values (numbers), so you
can use an XY chart.

HTH

Ed Ferrero
www.edferrero.com

"Cow Girl" wrote in message
...
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!