Unable to Have X-Axis Labels To Show

RifeS

New Member
Joined
Nov 15, 2011
Messages
2
I have the following data set:

<table border="0" cellpadding="0" cellspacing="0" width="216"><colgroup><col style="width:54pt" span="3" width="72"> </colgroup><tbody><tr style="height:14.25pt" height="19"> <td style="height:14.25pt;width:54pt" height="19" width="72">YEAR</td> <td style="width:54pt" width="72">C %</td> <td style="width:54pt" width="72">EQ %</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1804</td> <td class="xl63" align="right">20%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1805</td> <td class="xl63" align="right">20%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1806</td> <td class="xl63" align="right">20%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1807</td> <td class="xl63" align="right">17%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1808</td> <td class="xl63" align="right">29%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1809</td> <td class="xl63" align="right">29%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1810</td> <td class="xl63" align="right">44%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1811</td> <td class="xl63" align="right">56%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1812</td> <td class="xl63" align="right">55%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1813</td> <td class="xl63" align="right">73%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1814</td> <td class="xl63" align="right">62%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1815</td> <td class="xl63" align="right">62%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1816</td> <td class="xl63" align="right">62%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1817</td> <td class="xl63" align="right">69%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1818</td> <td class="xl63" align="right">63%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1819</td> <td class="xl63" align="right">69%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1820</td> <td class="xl63" align="right">71%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1821</td> <td class="xl63" align="right">44%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1822</td> <td class="xl63" align="right">35%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1823</td> <td class="xl63" align="right">25%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1824</td> <td class="xl63" align="right">25%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1825</td> <td class="xl63" align="right">24%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1826</td> <td class="xl63" align="right">17%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1827</td> <td class="xl63" align="right">29%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1828</td> <td class="xl63" align="right">15%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1829</td> <td class="xl63" align="right">14%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1830</td> <td class="xl63" align="right">14%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1831</td> <td class="xl63" align="right">18%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1832</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1833</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1834</td> <td class="xl63" align="right">14%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1835</td> <td class="xl63" align="right">21%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1836</td> <td class="xl63" align="right">26%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1837</td> <td class="xl63" align="right">24%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1838</td> <td class="xl63" align="right">24%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1839</td> <td class="xl63" align="right">12%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1840</td> <td class="xl63" align="right">19%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1841</td> <td class="xl63" align="right">22%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1842</td> <td class="xl63" align="right">25%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1843</td> <td class="xl63" align="right">33%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1844</td> <td class="xl63" align="right">35%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1845</td> <td class="xl63" align="right">35%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1846</td> <td class="xl63" align="right">27%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1847</td> <td class="xl63" align="right">27%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1848</td> <td class="xl63" align="right">21%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1849</td> <td class="xl63" align="right">19%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1850</td> <td class="xl63" align="right">21%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1851</td> <td class="xl63" align="right">21%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1852</td> <td class="xl63" align="right">18%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1853</td> <td class="xl63" align="right">18%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1854</td> <td class="xl63" align="right">21%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1855</td> <td class="xl63" align="right">22%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1856</td> <td class="xl63" align="right">22%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1857</td> <td class="xl63" align="right">30%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1858</td> <td class="xl63" align="right">38%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1859</td> <td class="xl63" align="right">38%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1860</td> <td class="xl63" align="right">32%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1861</td> <td class="xl63" align="right">42%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1862</td> <td class="xl63" align="right">42%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1863</td> <td class="xl63" align="right">42%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1864</td> <td class="xl63" align="right">38%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1865</td> <td class="xl63" align="right">38%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1866</td> <td class="xl63" align="right">42%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1867</td> <td class="xl63" align="right">48%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1868</td> <td class="xl63" align="right">48%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1869</td> <td class="xl63" align="right">39%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1870</td> <td class="xl63" align="right">39%</td> <td class="xl63" align="right">4%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1871</td> <td class="xl63" align="right">42%</td> <td class="xl63" align="right">4%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1872</td> <td class="xl63" align="right">40%</td> <td class="xl63" align="right">4%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1873</td> <td class="xl63" align="right">50%</td> <td class="xl63" align="right">0%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1874</td> <td class="xl63" align="right">61%</td> <td class="xl63" align="right">5%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1875</td> <td class="xl63" align="right">61%</td> <td class="xl63" align="right">4%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1876</td> <td class="xl63" align="right">65%</td> <td class="xl63" align="right">4%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1877</td> <td class="xl63" align="right">64%</td> <td class="xl63" align="right">5%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1878</td> <td class="xl63" align="right">68%</td> <td class="xl63" align="right">5%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1879</td> <td class="xl63" align="right">74%</td> <td class="xl63" align="right">5%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1880</td> <td class="xl63" align="right">68%</td> <td class="xl63" align="right">14%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1881</td> <td class="xl63" align="right">72%</td> <td class="xl63" align="right">17%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1882</td> <td class="xl63" align="right">61%</td> <td class="xl63" align="right">28%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1883</td> <td class="xl63" align="right">56%</td> <td class="xl63" align="right">33%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1884</td> <td class="xl63" align="right">53%</td> <td class="xl63" align="right">35%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1885</td> <td class="xl63" align="right">47%</td> <td class="xl63" align="right">41%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1886</td> <td class="xl63" align="right">47%</td> <td class="xl63" align="right">41%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1887</td> <td class="xl63" align="right">47%</td> <td class="xl63" align="right">47%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1888</td> <td class="xl63" align="right">47%</td> <td class="xl63" align="right">47%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1889</td> <td class="xl63" align="right">44%</td> <td class="xl63" align="right">56%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1890</td> <td class="xl63" align="right">32%</td> <td class="xl63" align="right">68%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1891</td> <td class="xl63" align="right">35%</td> <td class="xl63" align="right">68%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1892</td> <td class="xl63" align="right">18%</td> <td class="xl63" align="right">82%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1893</td> <td class="xl63" align="right">18%</td> <td class="xl63" align="right">82%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1894</td> <td class="xl63" align="right">18%</td> <td class="xl63" align="right">82%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1895</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1896</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1897</td> <td class="xl63" align="right">20%</td> <td class="xl63" align="right">80%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1898</td> <td class="xl63" align="right">20%</td> <td class="xl63" align="right">80%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1899</td> <td class="xl63" align="right">8%</td> <td class="xl63" align="right">92%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1900</td> <td class="xl63" align="right">10%</td> <td class="xl63" align="right">90%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1901</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">88%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1902</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">88%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1903</td> <td class="xl63" align="right">10%</td> <td class="xl63" align="right">90%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1904</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">88%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1905</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1906</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1907</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1908</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1909</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1910</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1911</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">87%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1912</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">88%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1913</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">88%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1914</td> <td class="xl63" align="right">13%</td> <td class="xl63" align="right">88%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1915</td> <td class="xl63" align="right">14%</td> <td class="xl63" align="right">86%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1916</td> <td class="xl63" align="right">14%</td> <td class="xl63" align="right">86%</td> </tr> <tr style="height:14.25pt" height="19"> <td style="height:14.25pt" align="right" height="19">1917</td> <td class="xl63" align="right">20%</td> <td class="xl63" align="right">80%</td> </tr> </tbody></table>
I only want the following years to show in a line chart: 1804, 1810, 1820, 1830, 1840, 1850, 1860, 1870, 1880, 1890, 1900, and 1910

When I select only these years, however, the x-axis refuses to show only these values. This is what I arrive at:


-- removed inline image ---


Any assistance would be appreciated.

Thanks.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Here is an image of the chart:
CHART.jpg
 
Upvote 0

Forum statistics

Threads
1,214,978
Messages
6,122,547
Members
449,089
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top