If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|