Bug in Line Chart Horizontal Axis?
I have a line chart showing dates on the horizontal axis and dollar amounts on the vertical axis. I am trying to get the minor gridlines for the horizontal axis to show every 3 months, and the major gridlines to show every year. Here's what I did: I set
the major unit on the horizontal axis to one year, the minor unit to 3 months, and made sure to check "Date Axis". When I select "Major and Minor Gridlines" from the ribbon (Layout/Gridlines/Primary Vertical Gridlines), only the major gridlines show up.
Strangely, if I select only "Minor Gridlines", then the minor gridlines show up. I can't get the major and minor gridlines to show up at the same time. Is this a bug or a feature? My dates go from Jan 1, 2008 to Jan 1, 2014. I'm using Excel 2007 SP2, Windows
XP SP3. The minor tick marks do show up, so I know the scale is doing what I want it to.
Anwsers to the Problem Bug in Line Chart Horizontal Axis?
Not sure it's a bug as such, more a case of it does not like mixing period sizes for the major and minor unit.
Try this instead.
Apply both major and minor gridlines.
Format the Major unit to be 12 months and format the Minor unit to be 3 months.
Both should now appear and can be formatted differently.
This particular error can easily be resolved with a few simple steps. However, if you are not confident in your ability to use the methods below or they do not fully remove the issue on your computer, you may want to seek the assistance of a qualified repair technician who is well versed in fixing Bug in Line Chart Horizontal Axis?.
- Back-up the Registry of your operating system.
- Find the Registry Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\OSUpgrade]
- Note: this Registry Key should already exist, if it does not exist, create it.
- Create a brand new DWORD Value that is named AllowOsUpdate
- Set the Value to 0x00000001.
- Close and reopen your Control Panel.
- Restart the Microsoft Windows.
Another Safe way to Repair the Problem: Bug in Line Chart Horizontal Axis?:
How to Fix Bug in Line Chart Horizontal Axis? with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The errors will be shown in the scan result.
2. After the scan is done, you can see the errors and problems which need to be repaired.
3. When the Fixing part is done, your computer has been speeded up and the errors have been removed
Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.188.8.131.52 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.184.108.40.206 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.220.127.116.11 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.18.104.22.168 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: [Solution] Busy cursor when mouse pointer touches an window,BSoD Again This Time its Different. [Solved],How Can You Fix - Bluetooth not working properly with Windows 8.1?,bsod on bad pool header + others Tech Support,Fast Solution to Problem: BSOD error message in windows 7 at random moments..,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work