From: Jon Peltier on 9 Mar 2010 09:51 Using two variations, without a secondary X axis and with a secondary X axis, I was able to change the maximum by selecting Fixed and entering 1/5/1900. Entering just 5 does not work in 2007, because they forgot that even in axis scale input boxes, numbers can have different formats. Make sure you have SP2 installed. The original release of 2007 had lots of chart glitches, SP1 solved many, SP2 solved many, and many remain. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/7/2010 10:43 PM, David wrote: > Date Series 1 Series 2 > 1 43 10 > 2 45 11 > 3 45 14 > 4 67 16 > 5 89 13 > 6 90 #N/A > 7 89 #N/A > 8 88 #N/A
First
|
Prev
|
Pages: 1 2 Prev: How do I chart contours in Excel 2007? Next: Change background / color of chart worksheet? |