Shading

  • Thread starter Thread starter Cow Girl
  • Start date Start date
C

Cow Girl

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!
 
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
 
Back
Top