More than 6 categories (series) in a chart?

[George88]

Hi,

I have been Googling and searching the Excel help files but I can't find a straight answer to this question.

My question is: how do you have more than 6 categories (series) in Excel (2010) when working with charts? I have my setup like this:

The first row has 7 top headings which are dates going from A1 to G1 (first of each month to the end of the year). There are 10 body parts on the left side (legs, waist, chest, etc.) going from A2 to A11.

I have filled in the the sizes for every month forward (just guesses) because the chart just plots 0 if data doesn't exist, but no chart type will allow me to use more than 6 rows for data (the series). Up to 6 is fine, anything more just messes up the chart. I was testing this by creating the line chart for each row and once I got to the 7th, the data stopped displaying correctly.

I have been Googling and founds web sites saying you shouldn't use more than 4-6, but I need to in this instance.

How can I get around this?


Thank you.

 

[pgc01]

Hi,

... no chart type will allow me to use more than 6 rows for data (the series). Up to 6 is fine, anything more just messes up the chart.

???

I don't understand. You can plot 50 or 100 series, the only problem being that the chart may become unreadable.

I just used RandBetween() to generate points for 15 series. This is what I got. I could have added 100 more series with no problem.

Can you explain better your problem?


<IMG SRC = "data:image/gif;base64,R0lGODlhcwKFAff/AAAAAAAAOjoAADoAOgAAZgA6ZjoAZjo6ZmYAAGYAOmY6AGYAZgAAgAA6kDo6kAAA/wBmtmY6kACAgDqQkDqQtjqQ2wDM/wD//2a2/4AAAJA6AJA6OpA6ZpBmALZmAIAAgP8A/5CQOra2ZtuQOv+2Zv//AICAgJC2kLbbkLb/tpDb25nM/5Db/7b/27b//8yZ//+ZzP/bkP//mf//tsz/zMz//9v/////2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAABzAoUBQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKDImjpMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0aFCBRpMqXcq0qdOnUKNKnUq1alSkNWMYcFHyxgYVGjDgiOHABo4ZCVhYXcu2rdu3cOPKnesWq1QAdPPq3cu3r1+iJv5CtXtVsOHDiBMrXhvYJ17Ej1MSHry4suXLmDPHbNwzMkwGoEHLHEGAKw4PDWxo5RpjAIvVJmG39Hxy8lPamnPr3k33ge/fvhdz5onbb3Ectp0e5828ufOVwKM7BQGChvXr1N0O37kcJfXv32GS/0idEq3a1bJLmp+9MvlL2TEEiFW/gPVW9s/z658bHTjR69iBJ6AEBBZIYAkIvoTgggwmyNZ2OnWn13HuMSXhfhhmaJKA/f22oYAgmgQgDTk1iKCBBmoIE4Q5XUgXhS4WFaOKNPLXoYAlAeiSgzGZ6ONJKBZYo1Is4jTjjzCRZhpqqt3X2mtbjWfWeizBSNWMQ2ZpU4fB4QBgeCr5KGYJMzUoAYMlBUngkBa06eabFrRV5E1YwmXlVHVqKReaYY5ZQn8jqgQiCFapKUGNcLqp0guMNuroo5A2+tacNmF5gUmXikceSuuhd59XYM1XZXt5jnXfWQgAsOkMqW466p5S+dMpK49BPTAiDb9Rd2t2JQ0KplSGHrpUpC/IROyxjraUqKJ6ykRpTaW2dSdNsrGqqlmoXutStEWNGdWt0HHZZUq+4iiXoTkhS2xby7bZ7FTP0sTtWtMW1pauI/Iak7i5lkuoYcQWqO6jvLX77mXxzoTlBzgwzHBMSpbEJGxPriYlDjdwYFp7pF7plr96DSxpsEJm2W6cBx+csEzzWlUvZW6tW5LIkrpE8popv2RwzlHJ4PPPMrz0wdBEE93w0ZP+NGMGTDcd08WcpmWqC+g50AEAAaiF/59kLXM3l7A897Rz2DcB7XNMF6St9tpst1100TPVIHcNLdEd18oxde2xShXGtN4IqZE1pdSvks3uyYazBHSmOLTddlFvD/3S3HZniTdMeuPZseaJ14R45ysB3bjjjDsVueQpUQ76TZe/lCfYEJcmceBOugabV1pvu/ldKp6M8uow/Tz641ENPTfqOKgOvFWt6w7Z7vay5Tucy5d9dkrEN3X6B8pXj7DSRkF9Uqdbrfa3q3xDD7P3bV0qeuPYO85U5N2z3xQM+OcvV/NbG/bybfaznvBYQrq0qaR0mOpJ0eoXwKDk74H6yw//Cuc/9WWlLGdJi+AymDuTFERP72tJAf8NGBXKHS9yDewJBCGYwpJMkGNGidhpaMca223lbxBwHtf2Bhfhmc0lI0RgSUxIxLlpb3stXAkMSrJEHDSRiSuMIIZCQ0Uqagd8z+Nb5owEFwQKsS1ITCJNovjEGlVRNC1ZgRrXqEaTrAAlb7yiY2hixKehTz1S89TGKIZBKiHHgsrBUBjFOMYoaumMaFwJG9kIlKY5MgNJm2MWd8i5tzjsaIMk5EzI2CxEMkCRi2zjTx5JSkhi5oXpmyRK+jaTG4RFPa3CFgU16ZQm2vIkZMQfjTxZxZeEUpQvKaUjG4hKycgEXLFbEg3HYsM9nqok6fmjFnviyvlY647GFGMut6mwy+bw8puJ/Mkam7aCDJQTksJkGi2HUsxVJuZ/gYTLEuepH3Ai8iT3xMwvz+m0dQqmnbWhyfXsKEuTkI9qz4wmBz0IyKZsMSih0Yk9z5jER/7Sn3oCKENVWZuHVkouEV2dOmWSThzsE6OE1GhJPArAaVYSpTwpaUmYVs6aMhKmOJ2JSqUZkziadDSym2GTagglZ3LlYn6E50xIkEOJYWAG9Zla/zQpTDheNKdYhcpOWRr/T0ryTk8y3adPs0pWw2x1k05Mq6YKisfzlC+hpwLVKzfq1ei9ZaQuSadYy8pXy2HxMEq1EFxoak5T9vWwxPxrBV36VcQ69rGAUaxLIAVUZQ6VmUWNzX0ulrGNBXYpXIWsaBG7U92w0iYb9KMHR8La1rr2tbCNrWxnS9vafqS0uTntaHfL296yjKtQtQ/V+ki4k+hxagrNiQcCcIL7BFeqKDnucXmy3OZy5bnJle5bN7aT6p7Ku9zVLEKFm9ybgFdizH2mcbeLXPXq5LxMNYkHRCVeirGXuuk9alNPQ19osne6+LVudN3bXvIS2Lz5HXB4C8zgDOnWtxCOMIQfLOEKaFsYsRS+sIY3DNMMc/jDIG6hh0NM4hKvbsQmTrGKD4biaFYTYxqoAA5GsF8YrvjGScStZlAsWRz72Htn5ehqefjjIi8vyDHp5VrLk8f7QneWQ36pkaccFXHtr8fGaahgqczll1j5OUhe/2xdYQLf/c4Xuwema5cr/GWm3MpQJaDOgs6EoH89CMuCGlQyZ3fZipVPPnnTMmjXrEkuycRf1cmXvloyZzVlKMyC+axSQkvovYgLPLtKtHV+4iccoIt9kFYQrVwiPoM2ebwnobEOV0npQFdaL5fG16Z1MqtRr+TTjw11lhlr11fvRFwjqrWtl4JrDX0OJTKTE575IumktLpzwkaSSUpwqz/9JlAu8RVVis0bmkWqRromYAL3LFSKNdMkL55qlKm1WfKYB6nFTeVboi0rt9zKOobONqLNFRVuJ8XblA3KsWkZbmYLetK6QaZL+DUuHOzbzn0JVkoAfpiBX7jgKrnkw/9eUuq2FthaAulvNsfcUrZwiOG/wgzACZRs5ljc1y5c9l6abZRn58XbKbkZzng2tgubbePKliRgD+7st7QcSDcjZM9xarag7WR7IzyJCeGCcZSQsrJ8Nndm5zsWDEJ5pTZfdZGX7r0fxi+IJLRJJutWx91UPS80b8mTcECC0rhSxqpWd1l9Z7/3FRB+JfniT9Yu9bav7u05Xyo2D5qevOsdOWF/fMpezr4Byi8oG888StbOQNLKfEJEr/ll+O7PEF7+KdtT3cPqCPQSI34ucSdK5HkbQpSQbn70Mzxin8h7OXYmKTKcWO2KOve6LzigvF5fhGt/9uwl5W2d9+02WdJDeyb6njjvDL1LuC6lFzvextUzuwijXkLKGW230+fZ63HS8YXqMbXxHjmriXwZ8RPw70QpotxigkSNlzWXuqFk1+c1Qv8GdvS3Fk0nA6e3F9vTelkFgLtEUWnEAGMVdL9XgJB3gFpCeA9oSFniSWl0Vd8jdDGhey4RfMvkZ0YFY3hXY7E3FLOnFBxIVpx0SPmkEidlFOl0dQMYIdmXfCXnFv5HgzUYgDPBS6AUSjixg3g1JOuncKS2eKeWHtEUTS+4EiNQAS8Gbx0kfxXGTSuUIfakSFXkUzmoEkzIV+sXF1d4FHFBT2WkEmA4hyx0GDdoEhN1h3uxT0zIgyq2hnaifbJXPXloRWFjTr9kWDDXE+vXdFhXbsNHhU4CaF64br1WFXnYV8J0hovYgy3ygyTXVSbWh01oUkrYiW73eXDkRgTFZG74hWr+FV7f14ZAEYM5I1NuxIkVWIGoqCKA+Ba0GF2UeBZRVV5qBjpVlYsi2ItZ9Yt1IYgw+BzJyInMaGJrCIePKHxEJYnclW4rBY1CYYvBVFiOxE+IeIrVmI4p4YzSAo5uqI7weEqqaBIBx3FS+IrcmC0hh3yh6FDx+I+VwY5sEYwt4X01Jm8AmZD/ZDg8RoLAKBfiqDAQCXsTWZGBSDYNqZAauZEZGBRoxl3PpWD2BYs+ARsfmRLaRZI8YZLFSGApaYw4UYUH9pJpdhMyeXw0eXw5AR/DiJL/5WQreSrxIXL15SRAGZQLxnUiaZQquRPJpZTrhWoAth//GcmRVhmPVXmVWsmMttWVXvmVYBmWYjmWZFmWZnmWC7GVarmWHcmWbrmRWfmWcmlkcTmXdnljdXmXelliI0YCABBUJTECACAWBrmXhulbLeYkZfFi8NeFkDcQJhCZkjmZlFmZlnmZmJmZmrmZnNmZnvmZoBmaojmapFmapnmaqJmaqrmarNmaksmQEcmPhzmbOqFjmZGXdEKbupkTtokZuPlRuxmcNCGQ9OKOtSicyLkZ84gSnzQTKMhWsVgSfgmY4NdRGpic2GkSYVaImdh10CkxAlEa+fh4vwkt2cll/WGB2EcTzVmcQCiK53lhbbYXxOkyxrmc8YlS8zmCFzh0G+/pj/lJS/sZFFB4Zw7JEtqWJEHFJCphPnnkGv/kWSo8uY/Zgk3uFKCgk2/fYh2yFiCeyEUf8nAiCk1elxIeEJ6wyCoyJnaWKBMuFmN0527xd6EYqiIDKhQFCmcMAh7eop4E6J/96BKwIZgEIRbX9J2yWaOWcaM28R2ZBjI4UAJwxhz1WRUE2Z9KShVQigMDKqKadh02YSaO5lcHumtBOmhZKhX98qR65iXYRmtiMqad84tk4pwLaqHH9X0IaZ1Slqa/xiUh4qYdyqEQdxM96mly2kJhRm+1RqJIeqJ/qZKqVYkG2Kd+qhKxNqhhuiAnMSss4W849XqH2ljzZ6nZGWv5UibRVhJi0hKJyltVep3lKS+zaWWKJmerahT/oLofn8MoV1amfXGl64ljw4YTXBJsJgIeheJvsONyZLcSyPKhuRlDd/qdjTeYLFqppMphjIom0fGmeRaowLKrz/EmAJcsxkIwkYSlaNeua+OoKwGp4lk+izlXX9eWlxhA3VqsqnorHtIS5bJtrxoUvqoU59ooz9ossWqqHnZeH3mS92oVnGqo+8onT+Gv0rESI1oV5GqwB1uPN5Gw1bOw29qiMcGSwgWx1bkW0gYX90YiJcFwAIto5BKwSiFxBHuuMAGyISuy/kSy+YqvyiexnQYUBZoSMusd+8YXHXsSFKcXPptr+IkTz9mg9wGV2Sq0QcgWR+um4Lpw/OKlhboWXTyLdIaCc5UxPX+oWA3Ytm0Lryohr02JtZSqtfBZFYNKA4sWs2HbppmBtvoRtT8GtENrsnerpTa7GCsXJDtbLLshuJ1IuFtruAAaNk+LqEn3LpDLVw8zUA5IFZJ7uP92W7ltUbaNSzO3pnOgQ3mjlYC254iCJxWAWIovUbU+yRXcZ6HHSLlbxhYiIxM616zVs7mlZ38yEUZq8wFqUzmfCy+KRYrQO1IbFLcoWjWD45hJyrtoCheMorq0xLpi5Ig4QTpQF7upUwMXQESAZ6BYGmn3CaxrIbwNRLyJY7zNh3YwMYMqEX2HEbqky6c4cT42UJiSx2FqyzOZMlCMY3/tOninAxP8S6VTe5FnChPFJ57E5ZgfBGHgW7+W13TvKoMPzBIRrCX+m2rVarXc1X7Zq61Bu04d7MFnQ362d0AKNMLnu3+KqljB28M4M70mWr2nwsI0WqolCzykF0DCc3v/xYPDJlHCPzvBD/mfvasnSZxCosPEMohJmQTFUgu/M/e+7ZsbVxy+lud8ppN7U7diJ7y9RvzCc1HGtFR7C4h7alw5r9bGgZnCtyvAEXqdi8h8mILGRpF6OqyQYcZwipye3hmvQkw1EGp8f2yqJTZQJSHIgVfHkKPGFoaN6zqsYvbGhathIQS7mkwUnKxh6efJ0gqcQCrKk4tYmDzI8sM45ssTC2SCvJV+maHHRUfFbmzGAzR+pyzC3HM80geB4CbFNWG7CsYqYgE4SPqNwGzBVoM155HBBawl9nu/hDx4Q6TDG2dCb4N+RXh4ijU96pwocBvEkUoxAgAAFLAB2Lu7Ri5sXmIhOHc3YwdZt7vRzScRRE2hfylBNCcEWcqsGO35yT8aygAMx1XhdC0xywFNwzehf4esE4SneSXRvA2U0LyBhD7qgxj/OKsS+RYXYDalg9FrnBf6i1K8LIb5tAJlyNAk/coPPcprkb63HBcvDdNFeEtq5U16mBJ7RXXMTBPOHJXSGakwFs0uKMagTDYNeFjnHIESmISLlBhhxtJeXUSxUaIoIbf52Jj2PLpVrCI/DVMe+IFZrdVr1BO0y75T/RfC2tCaUdW719ZDUtQnQY1BsYOtbJ4lHZtnPRUcjTQnsdZszdd9/dZWhY6BLdgp4Ycj/YmFDchWUc6OddVm5NemKNlLmIYSlNR2alkq3NSAOZ3cddc3zRaJ7dEBBNLMIYAl8U0huNU0QdqGE2Yv+9vADbONTL3vDFfcZYVSDU0HoABG2pI6/0nNOBbTMl2ILAHYlY2LBGfa7lnBtVsQFaCye9pXdBiHKSHU5G0Y3LnQJFVYNhXXVkfZo+XLolfNv9wW1TfURjHe3EQVIcUT6T1RUXFShFWOc/1h8i0jyf3abzHeKvLf6r0YfGjZK1Hgrqfd5Magt6va1/WguePamG3fJnHfgvHfEhVOhxHhiriRYZaALN7iIQTEY/3I4mVQCLCiZ23SLKMn6V095LSMhnngg0jf8+0Wd0jiGFVK1o2dQB6NQo7gbwHa/qRXPn6pJ7Hk4ZjgH55iyThTYTXlVK5TFq6gqJ3hdOfUQxrVTR7kJUbg5aiMuv3l7KRYYjXnc97OMV7cKxI4PsXl4SDaW1vu5qIN505h5e//yN3vEc/YWqHTDN059eehHeiCfjdhLquZs89cuM3I+OdHHekBOekM2zJEOhBGGktZ2yxbvumcXtpg3BNLPeNlTp2CSV98Pq0ZMo1JnupkiqX6PYd2fhJkbdze6Y08BcuiqxhVheq4PrKefsRoHcxWseWbeOvJnlLLHrQ47mptQU7k+ObTDlmEfpxpzuRusYvdDmGAWLDZiKdD7NT8Fd73HMvlvpVh9rHROtzuPK957uuiMuuuHO9s+e14du2Y4+9vCfDAKvCuQ/Bu2ZuXUZ5mHbEKr5EMbxnluc966s/2yYYUqfEWOcUcT8E8g/ARP/KKIfIkf/KRFlpHCk3xTJ2u+a5gQFEtpE7mMF+Sp7LyNM/UP3GTqZ3zTqle5RX0NWmTQonoRCn0z41aRU+hNd/0PSEbfsnuTv/ySNnUUq/zU58fs8qF0DxjWXO7IwmTRH9UMuqYObnz7Xa9YM+UYq/0xz2TP9mUOsHza29gSe/2J7HPdd9gT69eer+Udh/zCSUAX7/3U/nze0T42Hv2DqbyMx/16BP1hU+kE1AfbZ8VNz/zVj/5AlH5cr+Tma8tJiH5WkP5lj/0eE/1pB+YnX/6d89ub7/CAsH5AOD5lw/7M1YQorL6uV/7ro/2XBHqTM/7pv/5oG8aRFr4m1/6rW/8Y8/62HwSxN/8t/+fW4aN8thvJ9ef/dxPL9vf/eB/F98f/uTvUONf/uhfc+ef/ux/FOvf/vBPHO8f//RPJ/Nf//j/W/m//8F6/wCBQ+BAggUNHkSYUOFChg0dPoQYUeJEihUtXsSYUeNGjh09fgQZUiEAACJNnkSZUuVKli1dvoQZU+bMkSVp3sSZU+dOnj19/gTqkWRQokWNHkWaVOlSmkOZPoUaVepUqlVfOo0Yw4ALgjc0YBA4AwGABjasnkWbVu1ath2xOvQQ4MTWgTEOKAA7YwFXrVzb/gUcWPDgpW8f9hU4ooJXsCTK4piRgAVhypUtX8Yc0rBDxCNIfq6gly/dhDYzn0admqoCCdX/pU1DRDyQcdixj0e2xp1bt0/WuwduZvna93DixUP2Hg58pXDjzZ0/h4jct3KVzKFfx45dOsbP3b1/Bx9e/Hjy4xFST2k9+3r2vrdfVG9UPXqU8dvfx4/5vUX7ROf3PwnA/AYkkK39KhIQIxI+s82g2HB48LzzEtSsQAsvBOxAiigUiAEPH4psMoFmi0EAkjAQCwACXIhrLr9Km1AmDjGksUaiNJxIOA935LFHH39kQCASIFhItAcjPOg/GW1kssmlcJSIwh8bClG2r8QCq68jSYMxyRmFcjJMMYGCMqIZd4xoQZJs8wyAAvDyakWBkDRIyZi+HDNP4x7gs08/cyoTpCI8c7ITpkH1RDQzPxe9kaNDbyr0qkQn1W3RP590FKpIXXqUUk+hspRPqwJ9qNOZNm3J1E9X9SlUUQ3M9ClUg2O1VqZcfUAkCXiL1SQ1yTLrIMRKPHGhWZezNdlWXVWJBmef5YlUhxIEoVprq6VSMiuzNBEAFMciQAQiBfIArC7rVJU/ZdeFCVeYQJDg2Wcl2BXQXgW6Nl9999VXyHETMpJLryow/zbGNFXkqsoYBmBhthH+lZBdiUNi1iV5naVXgmovpgFbezeidt9sRcSBMSwh3GpYAcwt2MuJkAwxBgfMqvLciW+eyN2UOB4oY58lKCHoEkAQugSggwZBJ2kbCrlfh35lk6Q3MYgzBO9YTtLgrLgUi2AIZ4ZM24K8w7lshXQOiWd8r/05Y6GvJahouUtQ+l6ljl1IZawHxuHhls2+GW2OOOb3WqPbBjqiwpP+WKN0DdVaUsBrFRwifi/m9yChEa83Q7uTwju9yROt+KDF81X7Ibk51+9zpEKvb/QBFy8dh9M9Tj2iuQ9vG7elGXpccnSXlB2/fC29faDcJ9qd95+L+//9b5GgDtZButSU8zaX7yz+ulA3xtxagZavqPmgWb8ueu1VpxtEsUv+CsJuv0W4Li6z3h7y7nfD9fLwOTKfQNB3H/XZDAfmQ2AAcTCkIu0lNiUKAMkiNjzu7U9RrsrX+OS1NsIxDiIJJAjiaFTACTJkbg6pGfy+laWU3Q8H5Vrf2IKXIwsOBoOo26BDhKaQBLavIANkEgnxZ8LdPYR6iZEanDSwojZFUHoEoU+AapiW/oEPWhfp4Q4VAsQ8CbFOmoocp6YIqhuCIIcSyeIJGcJFT3lxbGDMn/DGCBR3mfFZ4ltIGn2ouc0V7YcitIwFBDlIQlqgcRmZYarCqMg55kSJZ/KC20D0uEfmFe1om/MZagpJSF6BDI4U1F8jWYKrB4RvkirhXOcCuUlBEuQFr4RltFx3FNhJUZSU3Aiu5JVFmQxQlYJhZSsVAktivmAnboQiSo4oLIHFL4ZQTKSZbhk03cktVBfToshowsYQ/iWYDSlmOIlZN0865AIFOSdDUkii+aVITnbByxP/fxNNQTVykkJb1MUQkrlechOYwRRnQMNZkIAe024XQGhCFbpQhjbUXw10QWcW40wDzpN467onx/aYz2flSiHajIk//yJQkhpzI6/spOMics50jmxbJ9PSVtoEmmdatIJNuqcWG1ICjvXJWR79KD9fksq0lJSkwvTdLA/SUoEwdSHLbNPU4uSX2dRUIFE0CT3bklOdZoRPzwqaRqlZkMX1s3cnGWhGjFpQggTTkM1B5m8+KUOJLEhODiMSXuWJk7GChKty29nFGDWQ2znNrM9rCVtduda0OsSt7YnrVecKzZfRRWY0k8xlwybBL/LEjwn562dl0lNLNeR02xQpShhb/0yOfNNCkcWBVkUXx8NYFmwxu+375vkZz+rRJxyjAQ5IyZDCFq4lqT3palEqEMVi5LFNgq1sY0dbztCFb367LsSGyNci3gS4BiElUA1S2IWUVVeAVKtyTVqR5VLkuYiK7mRtGsqbIBAl30VIeE2XvKAg1yDqXa9O3suq+J5kmdbjykyzV0LK3rQt+E1IeMVrO/4ahagIUW5SXHuzAjfkAwL5MA5CXKT3sfNE7mzBBjhb0atKF3g8IR9CYnwQ/a6twjNpb0MujIPVLsWthexeh0H8ASIX2chHRjKSH6qQgEWUYSVTsVVj6+K9zoRnM85veItLlOa2LcNo2fAYhexhIsO7j2QmQwALI+pCGLJ4yhe9iRXv6MEsV1GoUQFwjtkyYFEOZMwKCXGgjcigYEVViUwkiROljFWRUNlyhZOwYauSZ8qEuc8K+fPrFkmrnBxvUR47y2oRu9hx7tnSl35Ipmm5aWR12rhKUW4qf7nKTaJ6I6qWD6uroxPz4uTLss5Ya069KhmkFJHybTGcUdPjEAJ71qnhs7I+LANqi9ig5WRKLbPqEz1f5Mt/BLZxhq0sape72OYu9rVVamBCIwQxXgGAot3/zOgK6aS5B2F2Qpx9nXF7Ct3pPoiR/w1wnODaIBlAeMJRWOL4Ectb7kzBXqal69n6Os8B1ve+sxNtPQ38IUke8Ycv8IFzjrjgdkt4ylW+cpYrfIHaNUiTS5QlsM3b0W6Oyb0R4uxnY6ffNvI4RUDe0IXWwOg9MXhBVr7wM18pzShbswtmEAHMrjiZ1OW0vVkrwHBb6OcF+rdGRp5khi7E6Gc/OjnX/RCE17XdfUsi1ZYodXC9iMHzleNNuk6jr7cn7CslOkOTHBG0F+TsSFdqUbTd6J/0HD8cZ8/fFxL4wAd88A4pPFSSHpTF17snjodO352D7oRQvuwQATnmD4+W/80DpfMJIVb2UtSgu8vux4MsDsERYm6DmD6hGUk9QzLvOWwXhuIN0axoRAN1KZcN8rs5Z7lxcAHeD8T3Hwm+QoZvmdb/5PUImb1ZHFP15tfqx+sZOLUpb5LsI2T7qun+RQ5ckL7MtFg2l/9jQrR8Ol2dVc83jupbqKBjv8tzv9UzjvjrGYhYp4Zrp7oLC93argazCDVRtPCrMiY5P/STvvWzPnTyiPYzPATMjjHjuROsFwZiMgcijRTCPwfDEAAMwA4kupcwwBFMuwJRQAFiQIZbIaiLDQ/wmiqjN5C4OW+SwRlMtxq0wRsUiPerkR3EAdBDCKiKu6lywRekL+dIwm3m4D0mdAkRhMIxkUKd+D4w8Y0NzA8aPL2QEDRrGzIlG4gxbKPE84/js6XMUMMBkb7pa0OW+IAaMEA6VJYyJBQ83LZ/Ej3s+EKHCkMjQ7tItCBDxIkzdIu02EML6UM/XKgmVDKjC0S0M7n9oURI/0FExnuKTLyQTeREhXrET8xBg6gBUSrFQVuT6qE/yzKRBau9N4NBn1DFVWTFpupEQBw8ErS1hKhFdfJB+TkxcEGB25I4Lcy7mbg9J6k+dPrDkwA5QkxGTLMbCRPHPlkygGHBhKkNXJxAvBOjb1yIYSQIR0SJbkRGd5yIZSSxpvvBmHKB8dusRTvCdawh3SMIeLQ+eSzAI/PGRIEBgWhIHHjIQ+IOZXo7Q5O7FbFAq/M/uvpFCyJAbURIkUiyhbQVGDBJxCu+uzlFz+uecqM+c2spMJxHSKxHiTHJm8TJk5SllASdlTRCwMnGgvw3V1QJhaxJZcnJnCyIh2RKdTs2Wf/xyY8IyNEzyIOUyYQksqMsyaS8ydWwQ86LSjRMFNJDCA9sKhDsCKOcRZvkSp1cC3zsSF/cQgwhy9K7ypSgyVjcyrbkvq/MiPkjCJWpH4DECHi7wHTMwOuoS7u8S7wMxbMbxVVpS7dMDbgEmGZ0OPohgGgkP2qciOUbCP5zoTd6jsUsS7P0iLXUPsgssr3kSriym9uTTSB7OYjqi5MZAXkTSLmkiJn7GhvwxywkTdwwzaVCTW6MxMcURDn8lMmELL+0iAbcxxayO9DsxSI8iKmrOtG0u86yjOIEycY8iUg8uuQ0suZ0zteCTvmryCucOzWhvd3EzuyEQMhAzPKjCvB/jMfjDAnyVE2EGMnIHJP0rAo02cm1Mz6sazWp0M/9FM+K8E+tBLTse0MBtRACVYspUbunzLawvMSeqDaDaFBirLyHiFCSFDonxI+IZNGDmMyIDAwgMdCbsMxqTLa4jIno+0LGLLoTlUSaADkLvZCGJFKI5EvL8JEV+JEV2NCJhP9KBd21nfi3SAzJoBBBMcHQytDQglBSD2FSp3TSDoXSituJsyNKpLjSMOHLIoXRGN3ShFiBOP3SA+XQ6Xk7BLMfv8BAuRrT6dqJmCyKIGXI11zKgWjRtXhThJDTRY3TgZhTiYQPifhPZtRHZ3y4umsRuuBOPgUlG5UJpzrLnEhTNSXUzACShWBUOeXSg3hUmlDAH2UIFTTHqMvTBdK/97HE9byMUXWSIz2NRDWIVG1UqXhVFP3HEXE6NduShJG4B8lVnsQMQR3UpEyNU4VTYVULKZzUhrBCNzk0v4iNPZWsPs1DyuDVXi1VUwVWghDWVrWIpQPTSH3STm3HvzhXdFX/ymr1EYVo15BouXhVl3nlyLmcinttEl9V131VVGxNiZZrO0gNWDGlV0Z6CmmdFIRNWB651lQ1CYf12AwAWARBNt6sV1EFsZONwyPzlCzFDGtlVY71iI8F2YZ4WDoN0wSd2KzbCYud1nxVjXUViH7NCJltixpNCMCs1Tm5nwh5VgTVida82HT9VZflUoatiI9tHWiVMX1yKWTllmdEmEz1C7HdSAr0VJmo0IPF2Az9kISQ0SBZWJiNCKLVjfjDsoKQVfA7x6RVWrtr2jrdn0OFSBdlWcB4W4XdWEaFCKxNn/W8W4KQTpiiTr5lPk4d2IvwDLDQK/ycHDY1UqlF0sNFe1WrXQiP1UFdrYhulaq569vAvJ+/hTIVaLjc0shx7Z4XpUzKONwg6dIeaVWhTQjGDSLU3Ym/vSwSoV104S2kxF2cJAjPbYvdhVuGWAGEY4B2dVeBEN5EMVqKvVyLmI3sSswCaV5qhQjBbdOfkF6qpYiUq96aHQjTZZfu1f9Zsy1Z5yjftQWJ6VWJ9d3dlGDUhHvfDBhglZMd+l3Q7/VenGjKwcWI/IXg9L2JHoEI/33bnmhXlStgAZ4iBI7SnE1gnYhgCGYLC2bfpchgllM6AxYz4p0IpG3dGM7MsmXHBc6JrpxaE57Rs0jhlLNHcNRahSBIJsPMBwxbubief2mz2PJQFz6JBpZgqTBhh6Bgqujhmf3h6EDdqjyIvM3OvY1hZB1CJibXRMwPHd5fqEjhLNYIBRxRyPVByaVVGV4Z71Tg+s0NNG4OhANeNv6I+PvIp2pPb71IcKUL+/MWy7VfG84J/uUIPV4P9yVdPz4JDybTRcbjCdbYhpjiC9Ht4EmmZJawZD+94xCmCR3e5CZhuT4O5ZkY5XLFZFOeCRlFFIcF5VaGWJEV2Fj+YJ2oYiZxWBxgZVz+iVc241Lu5Z1wZOKA14OQ32EmZqMwZhiu3MrFHr9t4iCeHJll4aC95WjGFG1eVXbtWhWyVM1kESTuTmfNZqctHgJe5aqVW3A+izHD3nvG3nLU2zmuZgiSINiV121uuQGu3m+mZ9ZDXSbNXvCL46fjR8olF5YB6Ihll3+VZwJW1YOujPj7XVsEFiQi5KmK4Sb653YGXEoJZnbt1zldaI3+C2NGRRBOZjGxaEeF5uxtaZfOVieu/0STVhiG2VycI5CU9maD1um65WlTLGOmSz4JHM4BqemiVtyjZg+YZkleZkAE8JqmXjGyYY+ozmeqJhCr/smlhr06thKC8RvOVQ2iDmuxjsKk9uj45NsIqSrbReZLbmsVluqphmsyXE8oLmcTu9QjdpG6uAusmWhdzgyLfuu/ppQxG2Hc1ecv5ufYUIy7JmOZ1uu/cGyjhuzIRl0cHuxkBUIu6QzvGMLF3hC2CObHDu2JiT/BfppBXt3ssWuK2uy8JuWo+FfYju3JIWupNOmbxYlmXuGVA+7gnkS5PpXiDmic2GA+XmXQZu4Odm5lq+FMjgkB9m6Mnufr/uHhFkvehoNlmnBfDhZvcCbvD+Xs3pbutsvp9Wbjab7TXHwRzP6MBWNtGtIJnKbvaI6/xsrHbTlnd0rnw76BKLNjrIbvAIdwkRizi2MrL445MGa+hZmMBSeZ/o6SCAfxSl5PAidifZTjZTWIJfZwaQrxFv9j1O22WLXtbx3pRCtpsy5rF9fxNs7uuP+cT/fe8SCviPaepR/vcSFv8egqjyVn8iZ3cuUwcnFG8ik/CNhSiyhnsvsUairncoKw8rTA8n2u5t3s8jIXiC9HizDv4lut3d028zc/8+JQ8wsfje586uL1iamsp57Q81LJc+/7c+KY85jT8l5Uap7o84njc0Bf9EBHdDlPdDiX9OsY9Em3dBqp9EvXdALJ9E339Pbo9E8XdUqPJr3CTbruv/5L3foJate18zFnz7uKn7XGb2Z69VVfMLt69VQfTVx/EV239WDfCGD/6RXj9Vt/4fopdjxldo0A9s6AOVgPYwWpH2gX9lqvjFD/zc3iagQblsnliGFJXvz+dn7OCHH/70xXL3dVr4gIOfZ17/V2X9pef+iHDncXEs56B3eNgBmn1ndzP3cXonV1t6x9D/juHPg8hXdkbwtt73ZioQAGJ/g6Z/fetK10V/iCB/iLQPdjnfjTZvjKsrt31/iKlwh3p/fJtfeNeJCucTeVN3iMaHmtfnlaXXl+x3d/h/mNt4h+N/adN/m10HbxrRJar5LxK/oVCfqt4QrxjcDJQHptGQGlj3eLb3oNUOt/OfqySHqe7/l5f5Gtt4GuX/raGnmu0Zaon4yp93p55wu0hmOo53qpp/qQZ3r5wZqnt9Wxp/u2t/q9P1axJ/uqF3nArxnB7/uyT/NIH/XGvwxtd/zIAd85DciX/MpXDcq3/MzHDMzX/M4nDM73/ND/C9AX/dIHc8Y3/dR/HdRX/dbnPNZ3/dhHdNiX/dqHlIAAADs=" ALT="MyPic">


I used:

<table border="1" cellpadding="1" style="background:#FFF; border-collapse:collapse;border-width:2px;border-color:#CCCCCC;font-family:Arial,Arial; font-size:10pt" ><tr><th style="border-width:1px;border-color:#888888;background:#9CF " > </th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >D</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >E</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >F</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >G</th></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>1</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>2</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2011-07-10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2011-07-11</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2011-07-12</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">2011-07-13</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>3</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat1</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">36</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">42</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">57</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>4</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat2</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">93</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">101</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">115</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">121</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>5</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat3</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">100</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">105</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">111</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">122</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>6</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat4</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">54</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">65</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">80</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">87</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>7</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">45</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">59</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">74</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">89</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>8</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat6</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">26</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">38</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">48</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>9</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat7</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">85</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">94</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">108</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">123</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>10</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat8</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">93</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">103</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">116</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">129</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>11</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat9</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">70</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">82</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">96</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">109</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>12</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat10</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">55</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">60</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">73</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">86</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>13</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat11</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">95</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">103</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">114</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">123</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>14</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat12</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">56</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">67</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">81</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">90</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>15</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat13</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">11</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">24</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">39</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">54</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>16</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat14</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">36</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">41</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">55</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">67</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>17</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Cat15</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">87</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">94</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">101</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">106</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>18</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td colspan=8 style="background:#9CF; padding-left:1em" > [Book1]Sheet3</td></tr></table>

 

[George88]

Hi, thanks for responding quickly.

These pictures demonstrate what I'm talking about further. I'm probably just not understanding how these charts work, but as soon as I use more than 6 rows, it starts displaying incorrectly. Sorry about these large images.

Displaying correctly:

Not displaying correctly using all data available:

 

[Jon Peltier]

George -

What web sites said you should only use 4 to 6 categories? That's absurd. Excel up to 2007 allows up to 255 series (as PGC warns, it may get crowded), and I don't remember if this is extended in 2010.

What kind of chart? How are you populating the chart with data?

What's the data range look like? You mention a header row and a header column, and it sounds from the description that the top left cell is not blank as it should be, but contains the first column header.

 

[Jon Peltier]

Your latest post came in while I was typing.

I don't think the chart is messed up. What happens is that Excel switches the default layout between by row and by column, depending on the size and shape of the data range. At first you had more columns than rows, so the newly inserted chart was plotted by row. Later you have more rows, so the new chart you inserted is plotted by column.

On the Chart Tools > Design tab, click on Switch Row/Column (3rd icon from the left).