how to built vertical line chart

[d_34_nz]

help me, Simple question-if I want to show values on the X axis, and show data/name/legend on the Y axis, then the line chart is vertical, not horizontal..

 

[Jobowo]

You could simply transpose the data (Copy, Paste Special, Transpose), or depending on which version of Excel you're using, go to Source/Select data and either (2003) select series in columns instead of rows, or (2007) Switch rows and columns.

 

[d_34_nz]

You could simply transpose the data (Copy, Paste Special, Transpose), or depending on which version of Excel you're using, go to Source/Select data and either (2003) select series in columns instead of rows, or (2007) Switch rows and columns.

i use 2007, if i'm switch between row and columns, its become like this..

but i dont have excel 2003, so i dont know what happen if switch that, do you have any suggestion about its (if 2007)..???

 

[Jobowo]

Hmm. Sorry, I thought you had values for C1, C2 etc.

But I see that what you are trying to do is to put data labels for a line chart on the Y axis. And while it doesn't seem to be a heretical idea it doesn't seem as though Excel will do this...at least as a line chart. You can of course get this as a bar chart but that likely isn't what you want.

I've tried faking it by using numerical labels (1..) and an XY plot with the thought of applying different labels later, but it still won't do it.

Will keep trying but for the time being am stumped. May try Excel 2002, which in some ways was more flexible.

 

[Jobowo]

No. As far as I can see nobody has solved this problem for line charts. Jon Peltier, who probably knows as much as anybody about Excel charts, has offered this solution but it only works for XY charts and not for the kind of data you are dealing with. However here's the link:

http://peltiertech.com/Excel/Charts/axes.html#SwitchXY

There are some chart add-ins offered here and elsewhere that might be able to do this, but whether? and for how much? questions I don't have answers to.

 

[Harvas]

I have a proposed solution for "vertical" line charts, but to display my solution uses MS Word.

I suggest you start, as you did, in Excel generating a line chart (categories along the x-axis and value along the y-axis.

Edit the text labels on both the x and y axes to "-90".

Select the line chart then copy and paste into a WS Word document.

Within the MS Word document, select the "image" and use "Rotate Image/Flip" within Word's Drawing tool bar. This should rotate the line chart to the vertical with the values now along the x-axis and the categories along the y-axis.

Hope this helps.

 

[pgc01]

Hi d_34_nz
Welcome to the board

To draw your chart you can use a scatter chart.

As an example, consider the table in B3:C7.

Step 1 - Add a sequence 1...N to use as Y values. In the example I inserted the values in D3:D7

Step 2 - Create a scatter chart using C3:C7 as X values and D3:D7 as Y values

Step 3 - Add the axes titles and hide the labels and tick marks of the Y-axis

Step 4 - Draw a custom Y-axis with the labels in B3:B7

This gives you a chart similar to the one you posted:


<IMG SRC = "data:image/gif;base64,R0lGODlhEAIjAXAAACH5BAEAAHgALAAAAAAQAiMBhgAAAJ2dnYaGhpycnP///5qammhoaE1NTbKysuHh4dDQ0PDw8IyMjKenp9nZ2enp6Tc3N6Wlpb29vXx8fPT3+4ap0meTxk1/vMfHx06BvE+BvWGPw3WDlWKCqEx/ulWAs4OGivn7/cbW6Y6v1VWGv0p+u0yAvFaHwMDS54mr01CCvUp+vE2AvViJwbTJ47vO5YOn0WaSxp+7293n8pm22VeHwO7z+bXK43ifzGyWyKS+3ePr9Ojv9q/G4XKaylWGwH2jzpq32WGOxNLf7pSz11uKwarC38za7Nfj8MLT6Jy42sjX61uLwlKDvkx/vHSDl1GAuFN/s3eezFGCvXOcy1KCvkt/u2KPxNDe7GCNw4Km0FSEvmuWx1OEvoSGiHeEk2uCnVd/r1CAuG6DnHGayXCYyVSFvmKOxGOQxMTU6VB/tlqBrmaCotTh7l6Lw1yLwl2LwlKEvl6Cqkx/uxEREZKSkpWVlY2NjQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAf/gHiCg4SFhoeIiYqLjI2Oj5CRkpOUlZaXmJmam5ydnp+geAUCpKWmp6ipqqusra6vsLGys7S1tre4ubq7vL2+v8DBvgWCAgTHyMnKy8zNzs/Q0dLT1NXW19jZ2tvc3d7f4OHi4+ThAsXl6err7O3u7/Dx8vP04+d4xvX6+/z9/v8AAwo0h26gwYMIEypcyHDgvXwNI0qcSLGiRYUPL2rcyLGjx4/SMoIcSbKkyZP6RKJcybKly5fOVMKcSbOmzYkyb+rcybMnvJw+gwodSnQa0KJIkyrdeXSp06dQSTaNSrWqVYZTr2rdyrVe1q5gw4oliG+s2bNot31Ny7bt2bVu/+PKvQp3rt27Sevi3cuXacG+gAP71Cu4sGGQhA8rXkwxMbwCAAwkOwBAAuPLmJk5frcAAIAExxR4XpC5dObN7wQAOHDMAIAGpmMzRu2uM4AFCUbL3m2YtjvVBSDD5k0csO92uT3fLs587/F2ql83n273ObvkpKlrb2t9XXLQ28O//Xvwu/jzYrurM4++/Vb16Wxnd0+fKvz6+BXfz88/8P7+AOL1X4AExjVggQiidWCCDIa1YIMQavVghBRGNWGFGCp1IT10lDKBAB+GCOKIIpZI4okmpojiiiq2yOKLLsYI44wy1kjjjTbmiOOOOvbI448+6lhATxvOA0CGSB5UpP88RybpJEBLxtPkk1TuEyU8U1appTxXvpPllmBCRx5IX4ZpZjldulPmmWyCk2Y7a7Ypp1pjfhTnnHha8yY7d+bpZzR7rtPnn4RqVqdHgxaq6DGBqpPoooU2ms6jkP4paTmUVprnpeRkqumcnI7j6adthirOqKSeaWo4qKYa5qrgtOrqlrB+I+usVdbqza24PqlrN7z2muSv3AQrbIbEbmPssRUmq82yzEbobDbQRtvgtNhUa22CkkowgWcFgCeaZchQptyg2m47DQVA2KBdoxNMIK5kCnxL7jGVUZOuutDYkEUJZ7x7KDyizYfMBATki4zC0uzLbzMUcFECFGaY4W7/c4EaMGQzDCd8bzQOP6yMDWaUUDLFAWM8sJcfK9OxcgcM9wwAqQQJ5M0254zzzjr3zPPPPrf4xQRhTFxyySWUoMYEQwPtdIwb+1WWPh273PIxCRwQNccij3NEBUibPLHJUJh8BHMZb211Mw2g2/U3SaSQ9NxzH230CypPXU8DrHF89TES9O1MyMe+AATdc3OhxAxKnLxCC3jnDVE98YKX9cJ/Zy0z129bY8MLEiNeguIGK9FCCZBTJ2kDrgFQAGnnKhydAX+73Pk0NugQOuJc9HDxMqZHPh221xAO6QI6hE23FL5Hg8R2xFtjPKGMKz93BcIHGH010+N5BBHWm4z9/7Urb9Q9m1+Hb0YKZ0tbvkbng/lCBaIDnMLzGG6vL78UvCBF/WdYnJP0N434Ielz/xNdAA02rPddxIAUQt7u6Na73+XKgRaBIIMYd4b6Mc+CtMJgRTRIICQo4V+iA8ILKCAnAjZMU98LXwnGtykRUoSE9Zmf+irQPkvZcCI4RI8ORWeGEeBPUS4EGZ4QWL8sCFBTSYRGEJtjgx4cTnSkc1UUZ2amGfQggbzrwQx6tcXBbWkGOuig6JjHwFmVkXNOMiEKESeFF4BQWG9kxhQZc4TG1Y+G/MrjMvZomBeMYIc9FJkgbQehISKuiIl82yKTQUi8fO6KiHPiGG+XjEkujP9AC/BfE3WwSU4qo1vfcp24qkaA3AjOjEJUgjK8CEYK6qCNpkQGvOSFNdbUi5UCcI0Sz3OEio2AAF5UIx1vmUtoBEoCy1EGwqqWANolqpJgeYEZylax+qnwjs00lN7oMQG1UbJlAlAANIe5nWLaDXHYY2E4jfLDTtXOY8m43DqliIqgPe2f/gwoQEH0hLGdbG5heAIpPjQiDy30oQ0VqEQHOlF/mrMmgWIl5jppmX1ycTtSgIJIxWY9KSghkvNsRtoGd6/LEcCjsNwOF05XtrLVL2mKOwI4UxoovrEUGdCMnQI+Gp6Zog5gSHhBCuaoQOzt1JS7nNdGlwFTOBa1CgD/s2D/lDDBR2KvlLlcXevClbBztayqemyPFFrwVAr0sat0M0MFdHDEznkSX+556jKOoINarlEHKN3WXROWISRYUYY4PaletVjPiGBTMTNwZBNH8AJcpmqwj72MDRQwAqZ69QVgJRVm2fSCIFjgpiYDAilF29iGZJY3fPUrHU8KqdH+CQl9RWwJTBrYUrWWIa/VTmTBhtosEKGyoPrtQoIrnlBWwLNxxZ5lfaVchTC3PaE8IWrl2oO6UnecZIrWW1FbAtX21n3gtRO/cCvb5Z1UnhSyrchwS9ybWkAJK4SQfDs3XN1a4KsI2q8pnXvam8oVtAAScDgp4ACuble13kWP/4JTeozYkpe37ZkwhZOBRinolgtBOAJ8h1fdhFx3Tl6sbxODgFy0lRghJ/aTc6FbNwDvRsMbnkZ2aZw07kZ4MTjOsTXGa2ApAPYyQRYyNkyIyfrl9DCo9IwAVvmxX9IMPDFVsjgMCwT/4teyRnZLVHtJgF9+jJdZkwxRtVyO/qL2DNJFhofNkL3xpDceBVvGNGunGimyuTal5bH4srBNk+mALSv1GzPG5ec/x+MFDq6f3eiclozes2rKuajLakbRTlfU06D+tKhD/aKIQvQVDP0CGIoWV4MqDQwhiheIZB2vWNt61rHW9Ews/dNliGZzaXX0OmzAVyV4GLXcHBsUuP+goBdzQ2O91rPbhB2OGfC1Au314KRNAAUpVNrZ2/CpopkxgVcGm9rZSKoOgFBg8iZNCnM9QnYo0EFuevvbd45H5UKjZnwejDS/bjS6pXGEF+TW3T2WQhB6IOJnSMwMzEY0uLnBOnCBJnbkCtxq7vnJgS+D2D0wtgkQXoIsGPkFP34Gve8t8XxzJMZnWsC1s43FCijBASmvxojxPbnwshkJfQQCXG8Kb7pO1zRJflvBD45wM5iU4TtX3cQFAvMEgdzYuqXbGU6e8/AkfVbW1gG2ST46IJy06+75OqTULXSyF13e6O25el219GM33aSAXWyApx6QqvMG5ESwu7udroP/F5wXWXwHiN8xI3Ox05x3c0V5CxP/j8UXRt0VGLoH4310M6mdQQVXQpdJ7nQl5B2KlPeH5dtydcGTl/CGJ2Pq+7F6sTR+7CTngmolb63PayepSsi82+MdWnX5HraQHv3diQDYzht/9vyoPVGuzoWs182ksc/x8QtzeymMHOG6L/zheQr9fUh/JkAPvubXSHyPM6r8VOMjpKWgzNfDm+HOF/b2x0J96yccv+PnfroEf/VwfhfRfd+XNAnIOycXgAIoTnKHKG2RfsJHcm9XfA94DfuHFKFHf25nenCXgWQRgfIgAWNFZclgZbrWcUHRA2YQdR93BCFXfaT3dGgngt3Q/ygGMAHZcTlmlgy8tAA7KHA94YImkAUgRGxKIHJ0s4BxZXbZh4O/QYDPAE1ttGfNgFaMVIRmYAIlkwVJEHyPR0HtJ4X0ECjlFG3KIG5ZphMuSFJOKDomoDinZ4b9wGvjtgwxw0+nUCJfACJ/yDSAOIiCWIiBeIiEiIiGmIiMuIiOqIiQSIhgQFI9hjhqEAZgAGt/aAs+0lCmhjOxNmuiSGuhSIq3Vmu4loqouIqmqIqtyIqn+IqyGIu06Iq1CIu26Ior+BJ4qEd/w4ZtaBONc1DWo0IwaIdQQoXOAG15iAx843wGWA5+dDJxuFsucIzIaCXKyDbmdk7KkGfsxBOmY/8yR2hYQ8dG2fgPY1ZmgtMxojFULxQUfnQGv7MAX+Rkq5WOKbGNzlBxrgM7ZoUvsUOEPdE44HRJTfRE+hgPG6gT/UM/RERbCzmFLmc+XJE+RMRDE7kODSkUfRQ+JgBIGzmCJhGNB8E4NOZUI/kNHZkUaNRudKNC+beSMcGPWOIWkQWTiYNgNKknNuklc2GP7WUB+diTgPKTamJJhpOQN0iTLakVDylpEmmUp4SUcFIYGOlVS0CVA1iR8KMYR3BIf6QA2JiOT3kWcvRHLbaRZ5kWKOlBa2mWVsknspE758hM2diWclFFQ5cFeCmFemkXTBSRTclmgYkX/dNkdRMEhan/fXMpKOeRBCpWYw5IYYcpGFk5N2owQ3WmZZdpGEgQBDIUZ575mI7SHzMQBDQmk0L2mZeBPDr5bn8ZTq6ZGfYYm6Mzm5wUZVcWGlXDaOGIIJ/Tl0rgXUhQAp15LDrIS63kS/aSgs8ZnAySmJLGmASABEdTmajnlewAjkDob8eAhdIZIfMjaUdTMcmJK4nmi4PEcSyYJJmZNDZVMdq5KL3YnvgJMpw2avxJav35nyfiiabwBaxmN2WjBrBWawq6oAzaoA76oBAaoRI6oRRaoRO6iy5xn2uzoQT5JDPQTSLlhWYTLeuZn944nk6yAN10nvWJRI8JjBw6VR1KJR96Mi3Q/6Iuyp3ssG9l1m+spFGDdCY20AJQcKPPp6Ps4I9khXECqRzuaZJ38aE4ap+mOSlcyRu1eaVjkaVa6iBViildGhtcGqZcMaZkKiFf2ilnehppKiprihlm+qb20aanIqezQaesYqdAhqexoqf6wae24qdQBqi7Iqi9QajAYqiFEaeKihSM2qhE8aiQKhSSOqmDgajFYql8UamaKjUk+HKdKiCYqiyhehecWqoYNarPgqpzcaqsChOu+qoZqqrU0k8kYqG4mqu6uqu82qu++qvAGqzCOqzEiqufCqu0ig3HijYZtg4UkBzwSAABEBnJiKSN0awS1g6uoWa2gWV3mKwaiP+t54Ew3ekZQ6Ua/eYPg4WhxMGuvOGu3fAtBsAe6giusgoTyUEZyzoPg3WvGxEd0VSt++qvfdE6ABCt9WqtBGsX0HQA8ioQ/bqwFEEZEmAb7skl9iqxJ9E2faMa3aiNCquxbGGxx2AbwAayAyuybsGxydA2rxWxKuulIRuz+pWxNCuqM3uz3GKzOtuqPLtolDGvBxMZ3iobAhC00SqvRSsbCwABWaK0NpFH5FoAEHAMETAkwTEdbWO1WAuvUOZRV0sAWZuqOZsQ+2QAQ6UAHysbo9Aaabu2mSEBEpAbyIC27Bi1PxsTG/MZrQSlNOEZBpAdfEu3vCGEfbswoEG4NLHkSGoruInrtzXxIfjyuMRxB5Q7uYdLtinLEO9YLmmbrsSxTwfwucQRO8sxuj2Kt2U7EJ2LDFlbACe7G20rtlgbu7HRGa5bu6q7udZ1LiXrGrxrGJBBM9khhDQzHYprvMGLGHnbs9zRvM7Lc9F7Qas7vfkBs9ZrIdCbvemxvdwLFtj7vUsRvuKbF95bvmhavegrHuS7vkPRvu4bFPAbv0RyvvQLFfN7vzqRv/q7u/27d/jQh7darARcwAZ8wAicwAq8wAzcwA78wAccoAxVCqFQwRZ8wRicwRq8wRzcwR78wSBsCYEAADs9" ALT="MyPic">


<TABLE style="BORDER-BOTTOM-COLOR: #cccccc; BORDER-RIGHT-WIDTH: 2px; BORDER-TOP-COLOR: #cccccc; BORDER-COLLAPSE: collapse; FONT-FAMILY: Arial,Arial; BACKGROUND: #fff; BORDER-TOP-WIDTH: 2px; BORDER-BOTTOM-WIDTH: 2px; BORDER-RIGHT-COLOR: #cccccc; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #cccccc; BORDER-LEFT-WIDTH: 2px" border=1 cellPadding=1><TBODY><TR><TH style="BORDER-BOTTOM-COLOR: #888888; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px"> </TH><TH style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px" width=30>A</TH><TH style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px" width=30>B</TH><TH style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px" width=30>C</TH><TH style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px" width=30>D</TH><TH style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: center; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px" width=30>E</TH></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">1</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">2</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">3</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: left; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">C11</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">32</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">1</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">4</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: left; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">C12</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">26</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">2</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">5</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: left; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">C13</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">38</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">3</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">6</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: left; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">C14</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">30</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">4</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">7</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: left; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">C15</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">36</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">5</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: center; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #000000; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BACKGROUND: #9cf; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #000000; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em">8</TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD><TD style="BORDER-BOTTOM-COLOR: #888888; TEXT-ALIGN: right; PADDING-BOTTOM: 0.25em; BORDER-RIGHT-WIDTH: 1px; BORDER-TOP-COLOR: #888888; PADDING-LEFT: 0.5em; PADDING-RIGHT: 0.5em; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-COLOR: #888888; BORDER-LEFT-COLOR: #888888; BORDER-LEFT-WIDTH: 1px; PADDING-TOP: 0.4em"> </TD></TR><TR><TD style="PADDING-LEFT: 1em; BACKGROUND: #9cf" colSpan=6>[Book1]Sheet1</TD></TR></TBODY></TABLE>

 

[Jobowo]

Interesting. This is what I tried and didn't work (see my second post above). That's just a caution to d_34_nz that if it doesn't work the first time if you play with it, there's a solution there somewhere. Perhaps pgc01 has hit on the right arrangement of columns and rows (Excel chart does seem to be sensitive to this).

 

[Harvas]

I wasn't suggesting to transpose the data within the bar chart, which is what I think you proposed in your second post and was shown in d_34_nz's response.

I was suggesting you rotate the full image (with the lable modifications) after copying (as an image) from Excel into Word.

If I could figure out how to post images I could step show each step visually but I haven't discovered that secret yet.

I did like pgc01 solution with the exception of step 4. I could not duplicate (easily) drawing a custom Y-axis.

 

[Jobowo]

Harvas, were you referring to my post?

I wasn't suggesting to transpose the data within the bar chart, which is what I think you proposed in your second post and was shown in d_34_nz's response.

If so, no, that would be my first post, nor was I actually responding (in my last post) to your solution (which I hadn't noticed at that point). I was referring to pgc01's solution so sorry about the confusion.

In my mind, your own solution would work fine too if you just wanted a final image for, say, a Powerpoint presentation. Of course you could achieve the same or better in an image editor like Gimp but Word would be easier for most people.