Advanced - Customized Chart

Fernando_Merino

New Member
Joined
Jun 26, 2012
Messages
4
Hi, I need to create a chart which have two columns, as xlCylinderColClustered, but one of the columns must be as xlCylinderColStacked, can someone please help me? I have tried even with some macross, but i guess in excel 2010 this kind of charts can't be combined into one single chart, am I wrong? Thanks!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,883
Hi Fernando
Welcome to the board

If I understand correctly it's just like with a clustered-stacked column chart, you just need to dispose the data in the input table in the right way.

This is an example. I just selected C4:E7, inserted a cylinder stacked chart and switched X-Y.

Is this what you need?


<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 >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >D</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >E</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >F</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>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: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>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; ">a</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; ">4</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>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; ">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; ">5</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>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; ">c</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; ">3</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>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; ">d</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; ">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; "> </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: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=6 style="background:#9CF; padding-left:1em" > [Book1]Sheet1</td></tr></table>


<IMG SRC = "data:image/gif;base64,R0lGODlhhwHIAPcAAP///4SEhKWlpebe5sXFxXNjnGNCe4xrrbVKQoRapXNajHOEOs5KSoRrrYytSkqMxWtKjL1SQqU6Qpy9UlJajHNanEp7tUqEtVpaY97WxaXFY71SWlKMlOZSa4TmYzFKa1J7xeZa5uZSEOYQ5uYZEBlazhkQnDFajEJzrbXmnFKlGa0Z73sZ77UQWq0ZxXsZxYQQWkoZzqU6IVp7ISkhY97F3lJCY1JjMbXm3ubeY1LvWlKlWubOMVLvGTGU3uYpYymUnOaMMeacY+Z7peYxpRnvWhnvGRmlWhkZ7+a9Y1KEWuYIYwiUnOZ7YxmEWow6MXspKaXFUntaWlIQY0IxWrW1nK1a77XmY1qU5nta7xBaYxBanObWnK1axXtaxeal5kpazkoQnOalnIyUpVpCc3taGWtKhOZ75uZSMeYx5uYZMRla7xkxnIRarYQxWkoZ7wgZY62lY7XvIYSM7wAIAHuUSoQZEK2EWkpa761jlEoxnK0ZKYzm7+alvXuUGa0ZCIzmzggZMUpCOrWUEJSUECkZMVoZEGMZMYSMxUJjpbWM74TOEDFjnIy1zlIxY4TmrbUQlITmjJQQlEIZOlLv71LvrRljOhnv7xnvrYy971JjEFLF71LFrRljEBnF7xnFrVLOa+beEFLOKRCU7+acEOZateYQtRnOaxnOKRkpzlLvzlLvjBlCOhnvzhnvjFJCEFLFzlLFjBlCEBnFzhnFjFLOSua9EFLOCBCUzuZ7EOZalOYQlBnOShnOCBkIzkIZECEZCK2MxZSMlLWUMSmlGXuEawilGZSUMSmEGQiEGeb3IaVSQpxaY7XOEIS1rbVClK1jKbWMjDpjY4TOMYTvEHMQlIS9jJRClK1jCOb35tbe3rW13ub3Y+b3pbXOMYRrpYTvMXMxlHuUOrU6Y4RCEK2MrYSta4QQMeZSSoTFa+/m785aSnuUjITFUmOcxffm3oxjjHt7jIRjjN73/7WlrbW1xVJCe3N7hObe1ubv3sW1xaWlrYxarf/3/4R7hAAAACH5BAEAAP8ALAAAAACHAcgAAAj/AIUFGEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3MiRoUAAIEOKHEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHOmHKizp8+fQIMKHUq0qFGcPI8qXcq0qdOnUKMCSCq1qtWrWLNq9Ul1q9evYMOKXdp1rNmzaNOqFVl2rdu3cOMebSu3rt27eFfSzcu3r1+3e/8KHkz4auDCiBMrFnp4sePHkF82jky5suXJljNrRox5s+fPeDuDHk1arWi56gQI2Kea9erWsF/Ldk07du3ZtnPj3n27t27fvH8LD04cuPHhx4sjX05c29rTcAkE0KYNX/Xr1rNj3669O/fv3sODuh8vvjz58+bTo1+vvj379+7DAw5QWICw0vgfQ1erTQCB/AAqth9a0uET4IGFDWhWPQIMgOCDgikYFj77/AfhhX1J+JV0zmHoYWj04cVgPh+WaJeGWfVnIVYZ5NOiiTCyhOJV+ASgT1MtZlCFOebEscCPdSwQ5I9EBskjAVWQGGOMM1ZFwBhKEuUiATwKKWSQWGJpZR1cajmkOD/GUcWSJTYZlQA3DtVijz+C6eWWC+wA55BvZsnlAmOSef+hmU5pE8CKP+FTJZFwzmmloXd6qSWQdei5Z4hr6SNAlD5lYM6VVyaKaZA7ZGmlnHH+KGedmmbg6IN8LqVaUIIeKiSooYZKJ6Kz1mqlEljeYOqpB6ZqlJ/1BFWFokDO+eaWi5Iq65YzKAEor/j5ShQB/lDqE62GGiukEtrWaaU4Q+oKbYDSCmUfUcUq62kduNK6brJ1ODDkDOKOm1+5P6lYE3XWXedvvze0+y6yiMLJ7ZAC12GOAwx3uYASM+yTDXUUUzxAv9pcbDHGGlPXccYch7zxyB6LXDLJIKP88comp3zyyy7HzLLKLc9M3Xxj1ROAtS/1p9rPrgGt2is3/Cj/8JbtFkxsvA5M4IAGEzjdsMML3DCGMEH/HNvWsnGd9ddagy302F6HbTbZXactdtlor6322WzHjXNYBAiwr40s3XDDDIx2SbXDfsu7MNQaFF74BBo40I4DccjbMJH12lsavjj1FyxNDBrIUidF980ww4gnbvjopBceBeFPM764A+b4vQC9u0pOGuU2UcvzS6u6pDe3V8obb+Osp96OBqcbXvzhyD/tNPDx3ll17LKDRjvmk9KkjT/PrkR0kVwyvHDqohNO/OjHI95OHIuj/7nrSkQe/WfTx6QvTZJ2+NLunjPNOPiIh156/6jTQPoc57vX3QAH7xtN/HqGN5oIw24y/9Eb9xy3MHMsLoCmKx3yhre81fluSM9LoPQgVRVJ3a4l84vg3g7WPf2B72kCJF3xThe6F+6veeHKnggr0yQB0CFNAPAhHQThEv/URGcnbMn2PLc/9cWBcKHzH+kAmLrvTS1IM5iB/XaYmRkJ4h6CsFA+MACSQtxHJcCqSe5qoje+9a57imuc6ABYOhoWbnjCaxwOIadDv2ijBn+kxz728Y1v+KOQhixkPQa5jxqMy0xhJEkx9qGSEVlPAJezCee4x7TvoU90nxyfKA2HOBuur4Dtg15eAFmAQtrAAPawhxnsAQEzmAEDELAHBmypSwNAIJezNMA3KKknM0njWf1gRf8fBVCQI/pDczfRW8De+Ls4Ni0ddKyj+Eo5gcZ9j2rukwsgXTnLW9rynLJMJwR2yUszwLKc5pSlARq5JEg+6x5S0Av1khiTVxCqS58LHh7FN0oPFA+bAVTc+pwHu7rUIB6xNGc5MfBODMiSnbtM5y7ZaU6L2jKjs9zih8yEASACAIwykkkGjNgTaTLKd987n/IIF4V0ZDCD/TufTJlXwBC+RRvfiGg7dQnPWa5TluW8KDpvmc6lItUejoSRPUPyxZaQEIXT+ckmmcgwOZ6PjlI03gab5r0PBimVbnmoAeKJ0VoqlaNMZWdTQcrWiTKVmCbyIh32SgdtEICvdACGSq7/upJFQrOlRWNh8/YnU50SlHyG42A3ZRpQ5x1wLftI6jqdKlGNFrWjSR3qOUFqABucMa+EZUpqT9Ifk/pkiW/83sIA6L8Zjq5/nySrHrsEpoamZR8VbadH5drZWYIUl0jFqEQ9alwz2MAGY2DSapUyXZJcr485kaBiCfhCwg1Pm1AUnQPSEVB58VEt32inAehq17meM57rNSpIm2qGzdrSBlTAa5mqaxR/sMSSQ9lqproaPPR98olhJeUdUwe83d4JrWnBAHHf2k625nK+S0XuchXAYQgoQJf2sIF+R8rfohRjJfvI00zq4Q9/3MPFLX7xi+PRYmmy0HcBbUfUoPbd/+PZdpviXWi4iuEPdhQjHkdOMpKXrOQmM/nJTo4ylKecZBcbOQD4tcFwh7pR+tryqB+9qCw3WwAFFODMHd5laamAAX8EwB9EZgecizxnOce5zni+s57pvGc7ByAeASCySM2ywJ2k5LpHVHFKJMjEhcVhsqFMcOEQWsrELW5hOMRiOMeCgecSFZ7E7aiYP+phDh/gzN84wKm/UYEKKKDUwMSAI0bsoUKjpLqZs14VMqkSRg+YaRfk3x3FOj4qdrO84FTlWBRAheeWUwEYMLOHy2zmVp65AfFQtba1nepCtrIC36j2q6EdYkdElzTqKEQ29FJiovjXJGuUCYsHjRKiuT6xhftzNAcfqwEP3DSGTxugg8EEYbR02gb2IMNHW11tayMy1ds+QAMk3oACHCABrUwAuBXg6nHX0rkiLk0+Cv8ho3YP5cTWTfERBXDYleDv1wG19KOJfbzkFU54BAThDbD7FWbbgAy6/CWHORzuAiSA1Uf/RgOWLvGmc7sN3zB6uDVe5s2W+9yKqYDRC6D1CpgkG4Jlt1QIq7OWvyQDwuD5SXzdQkd313waPF3xSunEK2JREMoWy8Ft8N5Su/rbiLR40ydOeItb/BtHN7qZO/zqi+bXMd5GZAJGIkQMkFzsUblqvOX3JxU+DOYMk2l4R1nzADrNio9bwBOgkPew+BzhuMQlxxWg8akb/dSnnrjTtQ11qW+8AKVWAFMfv5gKHD0BiReJOoDhHHYAY92DNblQ3g2A/ig6JgCOiSw698b/Ao93ssjT5r516oAosM5vT3iCG6Cg9q3sfa1mGPfst/7wbeu+8Ad4uAKmzvh0kkHE/bAYUcdqBCgSAkBEAJBuJXcT+0AHmdSAe3VaJxEiZadGrgUTgtAsfANQ+pM4UfNVxPY/qHNsDLMMyyAB6UcOh9B+WuFzRGUP8ldm4UaAGJd7g7d7xwduGvd3EFAAHmUDjiCBiIF4RMhqIrEPCJgN6oZ5NPFFkQQA+QAMDkIAzGdodcNPKpEB98CCKWEIgsBJZRU8GjBz+3ZTdiRADFYHG4AAEtCGKKh+rKcW7xd0Q9dq4KaDEKdqhCdxqWZ4q5YA+zd7r7ZZz4V1iXGHNCgS/1ToIPcQdtGHE0+4D2QEEtIghCQRAJh0RPtgdjFxCFAABVJATfszWRNQhhpkOIyzAaqIABEgAQhwgieYfp/IhVjBbI5AVELnYRUAD60GDwToh0qnbbrXBhf3izs4dL9kUcSnGFJHhAUwEvEQgQj4iDeBARbiYiHhDxA0EgJBEFioEg+UE4YABeQABem3DAvADMfgAHewOOAHQ8f2RHcQBxtwBwywAQzAABGwj2uIAGwoAcuQfumHd3L4XK80S0NXZlqHdIgkjDcIjEe3cYvnYbz0f7SGIZB0OeyQTyBxD5Y4EtTHebSoPVDgBgLphhvQhmu4kvl4j+uwDhuwDgzwkv8v6ZKqGAFr2IopeYISYJJQcAhRhRZS0GxBt0vjxnX7h4gVMHEFsIe6p22JBw8Yp3FmFnvOFYTShRPW2JEoBwCCsI0mIX0kUQWb2BPjaI5PgII8uQz+iABreI8xaZPoEJM1CZP6iJP+mJKtCIsCyX4F+Vyw5GF+x4t42G0RR3gNUAEHoJgWp3XwMHQcB0yFmJXRdDkZ0FcAQIX0xhYysRo/4YmCcJIA6Yp5WZouCZNzuQ4dEJP4CJMx6ZasuJdtKJBPcAitBxa2iIuyp5AbR4BLaYO6B3ETR4R3aIevxk74dZGPYhOCAFjqAAAQSAftJ5YggXYj6RK/8InqF5CwiAD/40Ca+uiSNkmTMPmS+IgA95iXEiCbbziLcthsBxl/ftdKSVlI+eeQ96eYjIl4G9dxv3RLz6WcEGJrE/gSSBQUgoCW6eeGrrgMeLkBOCmXMbmarDmTrMmP6/mKoymQtqkWCuBpGRV8s1d7EcmU9+d03RaRrDZ7EFABGWUP5kaZUCGWDDIU43gICyoFAMmWbfmWrGme5bkOqWmXPsqK47CW6jeQt/kVGACfsBRt05aUgHd09td0gqefBEh7gvifnTZrMvoU98ASK3WdMTEJCnqObciGsMkACLAO6PmjGzCXFWqXOBkBrOigo9meUHCBYnEPRLlLgjl7rjZ1UZd7wfiU/wdAjPlHnFHnn2oGhIZIYmNXWFmFOUhCAPWAqZqaqZnqhWjphieIkxn6ljUZpz/aAeYJlw/qj+vZhlKQfutXIfWgD5xKq5hqq7Naq7p6q7uaq7z6q74arLiKq5qqD4LgpMbVcXeIcUXokINXcYu5mEinALzYfyDnD7SarfWQq9xKq926rd4aruA6rt86q7tGq1XgrVXAiWJBoGFZSSxnPZiYqQRQr1Vgr/VKAPrwCiUpkLA4mnYKoXAJp6qZquUZAfdopxEwDrKZlun3CmmXrxI7sRRbsRZ7sfl6rxKrsRlbsbIGe/Ulf0Pnm7jnh3u4bUmXeAwnmMMXDxj7sjAbs/8VOzczihIpJG/VsxKeqKBtGKop2Y92KZOmSpM/Cpdt6patypNp+YlxmBav907yyXUYB27w0EoRp4e4h6W/B4gsilwB+qVOMV3Xs5ktsXldCAWh6bAnqKF26pZsSrAUOqQVCpsRgKd8mX6HwKdhUQx/Wl+yx2EyeIfR2pQnG3GSF25ax3j3hZVSRZ0/sVrZFxMrxWsrcZawupalCbSnSZfmmZr3qI/9qJd52pdL6hVmgKzxx2GuNpX7R6VVipj6CXW9yaIfZlGyJqCo4rg+EaYjsVJ62xIEEA/fSBIJ6q9pyZNt6baqiJqnWqGv+bxtqbSy6JdpwbcgSkvBp5C/WLL/N4iohRSRxzh07hRikVprutsTV+UnZMqNYOkSN3qSsLiweMmm+UiXQ9u5zgubSDuaAWmSBJkWp4two8WbM1iYVWql0YqIgWitXYq7COKuJUFCDEK2K3GzL3EIabugPQuQyQuhrdm8QXqh+siKSTub6WcIQXkW1gt7g1iHZRaRJct0hatqjMpxieui42taYHsTwsBXH3mJIWG2BrozNGG5bsCdHAyb+Iiw9jukzCu0bbqSJHy3cLi+UWEPzaZwCOl3gDiASeeshNcGjfmHxoeMvyRLybnDNbF8zkEAS2hoaUQ/AkDBlYu2orm2pJmXTFyerPmj5ZmeOSkBO9mGJqmC/6XrfgYJqLLXcVFXe4zJlE4neKp2fDN4ZsG3S5O5GE3jNFHjADbhK+oQCCTixnphQjQxpjdhCOuXoz2rxFEsnqaKqgW7DuPgmkcbyK0IkLBKvWihAIKAcEgVfF3XxQ15tdrWmAPYn9L2YcblpYsRNdAcNZ98vijxV4GFEt04EO0LExyCE/xqjm8IsKT5lm7Jx0AapOLpljr5r0tryO8JmLE3mDJIsk35rDiIeEa3i466uD8sGOLlgZTHV3QcEtLiD8CgD3TAu4ZGPQPdEuOYthvss6UptEA6ofYLk+qsv0krkOtnxVDRpfYAf37Hcd/2xfiJtfr5h0mJjLUbYg7cF53gIzoigQ9SKBnUbBJICBL9IAuUG8EzkQ9p1xOCgKMLerytaprlPLSy/MdxiY85qaHS685OC58ZJX+J68isZqh7GIw0nHgrurLCt2b9/BfhkzpHOI1WddMlkdMJ+EODJROIZpbaiaaj6cFvStFBas6sebRK3KoSoKPrx8tncXAhrUtWzayta5hgnMCndnS0R20e9oIhp8n/PAFHSAUw/yEt0sBX2+zT3CwMwwsT42iSCxqqR62/MVnLqqmKc+m5QouX/sjOTyADCXrILUjVIauLdUiArGai3QuVvkmYkLm45UsYuFVKInGZDc0Wan0TjhvUQPHQRc2/UqyPMkm0FV2etfyWsP2PJlybHv0UhL1WutRxgGfAr/sNYox7+Dy1HXZhITbZnsEOAr2AUdGVFdx5CDrXT/Cvrdijbrm8rImq90vRsLkMDLujb1ibtp0Vrxd0I62l9Ix7M5yovL3S1CZ8VznWD9zcn9wSuSYURoyC1L2m6DmTp1nRcurUrNiWozu9DY4V73dO8zml9gnGfnh4tbelzGxR8r1fUhGSKP8hxC7BL0b+L9qQDxhMm/49zknN2n1csHEJk0yszrK5DKQNBfRQMdqQARTj5dQB5l3+5WQe5mU+5mae5mi+5mIu5vnggoo80l1Me4VKuLunasRojMZXdT7oTvjlD9sx5l4+6IJe6IR+6Iae6Ig+6DT7FCWWAcXQ0waqNZTOGqwhDDt7xxzcj/QbAdmtmp7ex6Dr4in53W4AsW5D6aq+6qze6q7+6scKmOW92/V54zSMtXxYhI4dbizqVrLmD1kDG5b+GsNe7MR+7Mae7LOBNcudFRAMxChRD+zwnD8dDVzohTiKgjq6th0coRe9muc8k3W6knvJzj8Z41cB5/UldMr/qoOCa3Ena3F5XsOJ62EeBaPFvZyZh82dXeRb2BKeSJugKshruoYUHafmKcvbfZ5t69cB2Zfh7RQzfkvKWsDfm4czPMY6GIj+KXwH99Lk4uE1odC9y1IrlrMs8c2a/t+myZqpubzn7KbPW6cvzuAeSgW36FHsDrhdzJjs7ZS8V0jgls8dH9KQqsZkURIHOhOo/BLSnZbbvp4/e7RBe6rmvN3pyaqyXcV/eZB/a8MzmHTCibWE5/Mqqrrjxku3i/TURRI1ShP5EACSrhIBr+mhmpdvG6RLXeAZLcVbbwjobhXqHqho75u9Ha1AD9wFIJVbh4wZRQUc3isiTxMk1PQn/9/sI/G+asvBq/q5F+3yzpuebqqmbpikT/C/BmeQFeVqrcZqiJgA94nrDaB0Pn+Hi1/0APrjkhoV1NfNNBEN/c4SxavpagrgB//Enw/IB86/5giUajGUOf9lwhyISVfP8H7nE5eyrs/naobvbN+EewUM1H5rIDHBp8wOES/dR9zfmw6bQgvLcjrLLC7zrNqw0xvxTTGHUKq6tkeAAHHg2wGCDQ4YbFDhgMIC3yp8U1ABXgUFECqawWDPxj4AHT1+BBlS5EiSJU2eRJlSJYAAAVamxIBhZYAMAgi8DFlvnzacIV8dehL0iQSiEYgiQLphHQKl65Qq7bBO6tN1DJQiMP+6waiEZRKEHsrQU+zYkAqo2LCHwYxFixQjOvyWwKHBAggPEsQb91uBBAUquLVoz4ANR8LIHkacWDFLl4sB5CuEUlhLyjfJChOg2JAbKEG5fl62gWlSBk6tomtKtfQG0a2Ndu0q1M2rDP0c3x6JwcZuA2bSFlDwVgHfvQMH4jV4sMDChXofBq8QWO1ujritX1/c8naGQnS8yzzJLh/ZmpYT/4LSWSjRrkhHM2A6VWqHp6hNI1gqGisC2F6DHqoBO+zMciSttSwKLqLnnKPrruTwEkiu5/5KUAEzzCBsDAE35HCmxhYjIDIA1KHDPJL8IaueAMZbzBAoBPGsv6yQsqr/RqduvPGp1axKSgIExiHKv/RM7DAx3Xaz58K1IlIgAQXgekggCO1SqEq4mhyuIgWSzIiK6ooEkyxtCsnmJe0cywAYjzAgUiQUxRIgs9sEUU8o2MaJICn84tvAvnWi6jM1HpfCCrZl3PgqrDATM4s3DCB4NEHg+pLLIYLqsgvCNr7hlFLgKiogo8Ec0XBRU0NyL9WPsgHGNg9vm0cWfQAggA58TvpwpQyEaTMxQw7pzI0gDR1NtNVylC9QqyJojSkfPxsqKEECPJWsIwW7MDgI/HKooYmkfNDBBpaLi7gnmawIUgioq7ZdABCoEV4EPlJHxFdvq8G7ElHKNSUVWcTt/xUoEA1Kis/0RCq/Y/+ECscNGIiAx/264iooR7To1V2UGrVBLXsgQJDJvh5iSCC7HlSI04f4olDLC+0pTONTmcrzKpCAucc7w/jt99SeTapHAIBxc1E9rz4zikbWdsRRqmSX1W8DCV7zSgp7PviAWplXupbLBCkqrlJOHbzrgOUIaqMhubDU1sK02N06TIh5ZG1VOgwjABiecP150TdRqsGajBcDFsagKG6vWfhSQy1Q1qqiimasnpWCghNOoECLbeJeicCODwyZokmrNHvTTC+N8Eq/PlVr1FI577C1dSKe16N6PZKmHp5lLiYlbQK4dcNC6vQKNqSmHg1yq5BF5/9GHiXegBlmKEABBQoYOQHrvWE/6UgbDEgLwb/gCvs45ApqgyCG4npO28Aw8pL7DvFrdp1V7RVk8I/OdLdvkPQRQPDEog0BYMaABSzgPjAjAC2cZT1F8ZHiHheoG9EnR6WJADPgUQALVM+DJ+DA5T5wQBIisIQnNGEKUbhCFbZQGFUQgA3OYiC2VAgiFZDLcsjVgOQY5BubOoBc1paAv7hlLRlxBAYUGCcWNtGFT2yiogT0nofVriMkwpvedqcx/3WkPIf5Fz7ykQ9tjFEdZMwHPtShDSpowR4nUIsUntAVo+QJXsZCVlSkwow8bNAdIADBBQRpgQ5W73oU+ED2GjH/xjKiMY1jFKMjI9nISUKSkZaU5CUfmUlOllEb2pDCWb7nGwy4pYjl4tRxeuiggaxvQm1LkkY2okZtqBGNYiwjLh+Zy1v2kpeeRCMwhRlMmalDFjmjw+tMwr92/U0k+QiA7sgSJ5VgLZGXox4KCsAB4MADHgrwZjjdcQAONMAdD8DCOR/wABA8wALuJCQKEsEBFDCCA9jDmv7k1xEMzFAtNcxSX55Euh2SzWypI9kGQaUWDJFqnw8tCTOr1buR1EMYQ8PJrvQJElZc83qMQME9qydIkgpyne3EwgMucNIH/PECgCRkTOWZCOtdThpZgyhJOAa+bLUFInqp1PnucrZNqPUlLsOhCEVAhhGNfCmnT2WMzPrGKzCu6CU0sCYIGUEBmqKgkBZ46TrZeU4QuAMLZUXrOlf6UpnOs56Wy9zmoAqSe/jziG2BDnDgUheznQ51qSQOhSzisQzNFaoS9VlIfrdRoMnpJVq4JjZBWj1CsvWlF/hjS9uZWXaOFZAgkGkHE/FRaWRPa4YFAAYcwZu0uGU4RjXqD813sgakr0prk0iClpqRjaA2p/+INZUzARA0Afbkiz3B6gfgak95ciCml31pOwHJWbSS9bKglak9t8qIfPq2I42iIcjQJVC9HPQbpyNXEFW2l78UYFutI8zOvCs/4C6Koh3BTFUxupIPQPZyID0BTWka00CyE7Pt1Gw6pSvdy3awgxxIRCIYwYjSfkCuvvVebzDyNb0aNUplO936hlghkCUJbvPlXn0RkzNpLrMjBGRsSQC4PeQm8gMhzOY8YwpWQLK0up31rEovgALsyrN6WxWhFFEL3owcKDiT4lZQC3oygkgIIiNrG28diuIUd3Es9bgBFRjrEn1YdSwwRkxHI2u9ye44kC/9Y2ZBcNY4M1i6MU3/RAcpEMLsWXi+GcaI+M4FpbgItUElU1sBgKPUi8DPqVzemorHog5BqOMGg5sMZagppgBUITFZtZxIIbxj6Pa4rGP1sTuii2d61hPJ2aOxYQlEQy3lVSI5PChfw4U2vfCFL1lSAGG3DOm4SVos9zCMmPnVYrEQVzFwiGyAqTdgAq90syhF8Jw1C0hBYtcCXb2nCP3s3QxzKalY6lYqpwTilAH1XO6DAJcc8Whi98/LOMlbRy7NL/LYxDFYO4E0Qj1ZHVc2kAuuc5zZieAGO1ie1LNc9pRs2FCi5Z/ifXKUf6hDHhakbOptSEMU5FotK7Pe9r7NPvSlM1ydOQCzcoya/0+AvdHa89vYfTNnEyxdOR/c2x60Z8Czd2HUlhsDWvqLkwgNIbItJyEI7ctE0gWBC5345Ci/jrJb3hMCXBQ3ycXmCarXVYNHF87TXSdZUT1IVstz5n2e+Fxn/c9aQ+fKe+nrQR+UvkvlcCIVcG9w1NIl+V69XcYmy763/pL8Wqe/J7DHhEXqVTebNK1BzuwfP3uBts5ztCIkumEB3Vomibx8Hke9DtVLsk8FPt4Y6q3hsd6/lywWO1gVuuXcWnAeh5Xn7Dzrqbl98LaLXYRaiDtUmezkr+HwIXJhznkNWuVUUkqgEKiAsE0u+0UhnkP3/oizsSPzmbOZstU+8M7Vqf/5k7K18zW1HE7JvRu0XKiUCtpgQ1amShAr5yAk+ykSo7q0mDfuOzzw2xAEBIBNExDckwYk86Bve67PWjjhU7u0Yrsdq6dw6y7v2qmLa767gz7VC7HUwS2lCpWqGzYDLIkdiyfE8L4ERAmNOgxtqAd9qAcCuMEc5EECIADIuqagay4CAytByrxrO6v2Gz5CyjOaOiQRagQe5EF90MEprEIdpMJ6sEItxMIrvEEvzMItFMMu7EFBmCENu7+IML2GGBumaxD1MRuHeKV0SQuN8AccxEMtxEEt5MM+9MM/rIcq6ENB1EJCDMRCRMRA7JDKeiewgkEFxI57OIl/EZM4scT/F7pEGIqT5IKrAGu1PDO4hZOzJKyuU+s2sHKrDcSnD2AHSywgTXzFTJTFOLGGWYxFJoJFTKRFW9TFW5Sh3cgIkBG08SEiS3G6j2MO9Roi0RksFYwHV9TEaIwTaRQAaoQhTdwHV8zGONlGAdjGbxSAlog16+AxdwItelm5cRyJGBQQLwuaGrzDlOioyym/6wHFaiuwa9MssVowmCIkEOiqQ6qw0xI9JOmNSGGSK+mU88kUhHClAIQlDImfrSEAoVnEheu2kdgHQUgJdsQO/zmuL7PIlAC40rKcsXOusosuOTsnOsPAN4snt9Iu7vqAGIMdjgnGugMbHCoOvjobuwAi/6BimeFgC96ygcKrlnwQAJjrELNrJwugK33hyC2iPZGgxDNjQHkEuJkLobGrPJXqLJaULs8ivpiMMMwRIXV8qmvRMDMAlSb5tfJyw6H6v/U6F8CwEEfTmDLbLwEpQp/7CH1QE1oBD76RGeHqiBnjNKZUCWhLJLgyMsozuM/SPIVDJ+G7Lg10K3GzSc7xnMFzS0l5C/3Ltf4jCOPIISJCly3BEJjZvjCpSLXEjoNrsI+oAiroCCqoNKo8PJAIyWYLoJ54vP/qylFDP2tTv2uzMw2EsEQAoT4Lvbliy49BugV5vjb0OIRYjrQpqp/Cy0chQHorEgJiNs4RhO8ozGWCxP/ruC8A+B3ZTImsvKpEMskAm6mULLUgOym166xTNEu3S7L5wsm7siG4xDVdQ0aB4BRfc5KWoTrfOMpTwYcA6Myn8siUEAbvmMrFC5q+VAlt8IfyfAk1c06xyyavSgTQuiw50yyx1LyDozwPekKswYE/M8gkab7xYUPoy867IJ3Yust0GTzCEM8N6VDuu9CTyAeZ6AdWQMp1dE9/SxF/8FCVwD3l0qohBCsL8LlSpLOUGstu47xva7WgE6EK3ZrPvJAakgi/gIe96ivpQ8ZKoZRzSxDBKCwwqQnHkr0kVQl/eFI3yYd4nCY+HYusorkck0zo6izl3EfNYyvsCkgkwxr/gpTOG0XIkXOIoJpL7TwI2Boo92HNfipS67A9FvTTlCgETKOMAPC6M9sHT0sMILycEGKuyhvLH7PAHoOuDgJIetKuy9EcARUlEBQfvSKZXMsUoqq+vWjQT7E/1ywSAKrSekvVkyiG9oyoqiquwygEG3NOAaMpCOM82mQ/bHvU4SuymUIBzKmw5FtL+gOfo7MIvRoovTCfBNWhTYlLJnkfWSpVx5BPA7zWkoiHDV28noiTbj0MUEPLViOy3osuVKuzRm2nhosn62lXmoxO5ROlJME46CDG5WAIKgsXfB3KhVLBQHWM35FVFvSIgh0JQZBElVhPjyBP3IC2gMOesQupsHt8s7STriQ8Qoz8OQhr1/j7ABTznkArpW0ZtCeRS7IxiLRpDv2DiEVLF6aKveu4SpiN2Zs1iVrRF2BQh4RViXrwB4ad1a28J66Spwm8LrQTPjAtK5LSTFW8nICFqIoLr9BhGWM0rwc5G+qjFLjUElGxAQUQkIEFW5lNjJs9UuuYR7QUuwiU26LV3M/yRwtAWjajAGloBC4rN4zQWu/EV4aEEJKNQ6UjMbcR25SgQbAN/wnIhUFdkdLrSK5ralcIS8l/nFi6pbNGVasxBa1UPAF3gM+n4piPeRTAbZK9oguTzYsckkPAYwthWN4UMTPaBQnbPQwF/B0RvQ0OeEzMASkBW1TL289sO8Il9Cp5QoTthaprwQADYFMcehK1MY5OfToRezcFGINPEpDJ9d7vjV3HQEADxo4aoM+Z2yot5THK3FWyUrvrugBEQIQB4D4FsAEySBK3DJnX8jVjpLJ8FSK4OAB1sNTtyN0DRmCZqdmSICDG5JB9qNXr8crjpMAkJEW0QoRG2AYChtl98Ife+A27G45v2KBORR+S/YYxCIZaKpKvheEY5iKT+B0bHk8h5v+AVpNbBPOsc2qEORDieTjbK/YIeqiHMTgA6DDQZFU9swmGOq6HAUjjRQka+n3cBM6OkhC/rdGGARiAQSZkdcDjeWjhEVFjGl4jNaoBQpbkuPnNRt4fP1YM/3FcS+Zkd4Em8uVk8CULxASADIimTkblrdnjVMbiqgw/KmXlWDaVmuBiVhblsdDWTZblXTZVCuXlsMWNMdCX16xdj6gJUP7lZE6MVVbmW34Ms6UVLTKJNyEAdmBbZcbmyzDUX3bmfShMKmDZ/QGAxsvmcq5BXy5nZ76HGQ6Aba7dFzbneH4JK8ZmZ/aH+yoGls20VuXnlrjnALhnfwiAexjogibogzb/6IRG6IVW6IaOh2II6GJ46Ikuhnt4aIuu6If2h4Om6I6WaIjmaJAW6Y0e6Xso6ZMm6ZQ2aZVG6ZV26ZYe6IC+B39gh4Au6I0W6Jk+6I2O6Z3WaZz+6Z8GaZkm6qEGaVeV56hyjHuQAtxx5+9NaiiNapHAZBh25rzhiQygA3gV56mGaq/+6nh2ZgBQOe+o5WIG65hN664W66pGjHCWZ7iO66Qe67W267s2E7fG673ma97s678G7MjV68AmbL6u68JG7Kk+7MRmbHNe7MaG7GR+7Mim7FiebGLLUGQu5wylA4St7Nu4bC4TBAVQvKleUgBoUrn+bLEIbUjTurX2h6deAm2y/2htLivttC4EzZ7tnqhtFHttsM7W3QbtwYbZ257qexAEVxHuTCZuFvztqKbZ5R5ucz5PfeFjWSZb74Bm6Q7f5ubu74bZ3gbv8fYt8Sbv87ZQ70bv9Z4v82bv9y429Ybv+YYo96bv++4++cbv/ZYq/ebv//YZ/wbwAS8S+ybwA39EBFfw8hbwBXdwwX7wCH+ofm5Vgr7neLjwnZZoDY8HDvfwmN5wEO9wEf/wmQ5xEx9xFC/xDCdxEb/wF5doGMfwGKfxGbdxGcfxGs/xG9fxHufxH9/xIPdxFldxEDfxI79nJK/oJGfyJXdyJYfyJo/yJ5fyKqfyK5/yLLdyLcfyJgpP8YCuaQpviYAAADs=" ALT="MyPic">
 
Last edited:

Fernando_Merino

New Member
Joined
Jun 26, 2012
Messages
4
Thanks for the answer. Actually, this is very close to what i need, but i really need one serie as stacked column (like Column 1), but the second serie must be attached to the first one, so the columns are shown in groups of two, one stacked and the other one solid, like this:
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,883
Hi

I don't understand. Is it not just to add more data?

In this case I:

- selected D3:I7
- inserted a stacked cylinder chart

<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 >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >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" width=30 >F</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >G</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >H</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >I</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >J</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>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; "> </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>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: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:center;border-width: 1px;border-color:#888888; ">T1 -A</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:center;border-width: 1px;border-color:#888888; ">T1-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:center;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:center;border-width: 1px;border-color:#888888; ">T2-A</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:center;border-width: 1px;border-color:#888888; ">T2-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></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; ">a</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; ">4</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; ">3</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>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; ">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; ">5</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; ">8</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>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; ">c</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; ">3</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; ">4</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>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; ">d</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; ">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; "> </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; ">17</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: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=9 style="background:#9CF; padding-left:1em" > [Book1]Sheet1</td></tr></table>
 
Last edited:

Fernando_Merino

New Member
Joined
Jun 26, 2012
Messages
4

ADVERTISEMENT

Ok, now it seems better. I guess i just need to adjust the distance between columns to 0, and its finished, how can i do that in Excel 2010?

Thanks,
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,883
Try the following:

- right-click on one series
- choose Format Data Series
- in the Series Options tab set the Gap Width to No Gap
 

Watch MrExcel Video

Forum statistics

Threads
1,122,806
Messages
5,598,188
Members
414,218
Latest member
speedbit

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
Top