Dan in Germany
New Member
- Joined
- Jun 17, 2007
- Messages
- 29
I have a question regarding fill in a line chart. I have a time series and the X axis consists of Monthly intervals for two years (January of previous year to December current year). The data for the line are Chi Square values which will range from +14 to -20 The significance level for the tests are +7 and -7. I would like to have a line graph in which the area above 7 or below -7 is colored black. I've tried playing around with stacked area graphs however, when I set one data set with a maximum or minimum of + or - 7 then the slopes of the two data sets do not equal one another and cutt off at 7 is not smooth but rounded.
If this has made any sense, could someone help me in finding a way to fill these areas? I'm using Excel 2007. However, I do have access to Excel 2003, but only on my computer at home. I'm open for solutions for both versions.
thanks in advance!
Dan
If this has made any sense, could someone help me in finding a way to fill these areas? I'm using Excel 2007. However, I do have access to Excel 2003, but only on my computer at home. I'm open for solutions for both versions.
thanks in advance!
Dan