Rotate Graph/Chart by 90 degrees

[bofonomo]

Hi,

I've been tearing my hair out over this. but I've got a line graph and all I want to do is rotate it 90 degrees. So the Y-Axis is across the top (now x) and the x-axit runs down the left (now y but in negative order).

Essentially what you can do with a bar chart with the wizard but not with any of the lines!

Please help.

I am using excel 2007

 

[bofonomo]

Not sure if this make any difference, but, I am using text (catagories) along the bottom axis, so it is not a numerical axis.

 

[Steve=True]

Hi Bofonomo,

You can do what you want with charts and the camera, however, i would suggest against it as a line chart this way is difficult to read and seems somewhat strange to me anyway.

Here is what you would get:

Here is what you would get using a horizontal bar chart:

If you still want to do this, make a line chart, right click on both the horizontal and vertical axis' and rotate the alignment 270 degrees, then , take a camera picture of the chart and paste it and then rotate the picture 90 degrees to get the line graph shown above.

Now please stop pulling your hair out

Hope this help!

Steve=True
www.exceldashboardtemplates.com

 

[pgc01]

Hi

Another way is to use a scatter chart, you just switch X and Y, using for the text values 1,2,3 ...

Try it and you'll see imediately the line you want. The thing you won't like is the numbers in the Y axis, instead of the names. So, hide the default axis labels and add new labels to the Y axis.

<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">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></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></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: 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">Mary</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.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">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">3</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">Kate</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.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">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">4</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">Sue</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.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">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">5</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">Helen</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.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">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">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: 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=5>[Book1]Sheet2</TD></TR></TBODY></TABLE>


<IMG SRC = "data:image/gif;base64,R0lGODlhsgJkAff/AAAAAAAAOgA6OjoAADoAOjo6AAAAZjoAZjo6ZjpmZmYAAGYAOmY6AGYAZmZmAAA6kDo6kAAA/wBmkABmtmY6kDqQkDqQtjqQ22aQkGa2/5A6AJA6OpA6ZrZmAJCQOtuQOv+2ZoCAgJC2kLbbkJDb/7b/27b//9u2ttv/tv/bkP//ttv/////2////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEBAP8ALAAAAACyAmQBQAj/AAEIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEkyY4uTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0qNGjSJPuFKi0qdOnUKNKnUq1qtWrWLNqDcp0q1eVKQ6YaKFiAYmvWk+sCDsWrVcVCjK43frhwYq5V1lwGCEWr1UWG87e7Oq3sOHDiBMrXsy4sVbCjiNLnky5suXLmLkCyJx0M+ehnj9zFS00NGmfpk/zDDE4tWrUr2HH5ul6ts3atmnizi2T9e3dvHUHxwl8eMvixlciT55yOfOTvmtCfj7T+XPrzLEn126c+/Dour17nGWLkm2KAQMDkDCPXqB68uSPU5cpnnd9rRHy698/ej7M+7aBVx2AwREYm4GvIdjTfvl9peBpD5ImIH0RJujffxe+9CCDEVxW4WcfcjZhTNNlKJ+JLIWYmWsczqciZi9eNuJ/MXJWY2U34tXiiSiqlONkP0o2o4ZB4tijcpTtWNqRPjLZnJMoDelSiVAW6ZiVLnHY4WNQnoQlY18uJv/lcWFe2WULEWppZJdlJtYmYmOm+GZTcAEwQQvwiUVeWYI1Z5CTqWnJX3dnzmmYoYXFqRyiiDGKV42CLuboXJO6VSlaivp46aOFKibolkdt6pWoW5GqVaZ+nvkkm8xFiiSrsEKJKkpUAtpprDC5euCtsramKq282hrVp5ziyuSsXprqYLBMKhuTrj85e5W0ViGLJrVZYUuVtlNxixSxxh5pba2RsQWXXCiBMNAEdapHlgIAGNAWj8JWyWxNnyopmbdRjcvvtvf2+O9TAOqn2sBO+furlwGjiHBTyBm83ZkKL/ywUhd31umgDlPsq8UNm5jxTxwzHG6PFf86cqghi1YdMoktX5iyqisbVXNRN7+8VMz+zcyziz+7JbHGJ6O66LNkYXlwAUodYNBXtEFf5xW0ABdt4tHJxTdl1NmhBSqXVmeIdb1kN8v1xF2ObXbYF95MlNugefzbwmieTSjb/sEtlNpH6t2fvXgDnfbHKts9nN9AIQ714HODHDh1issGeK+NF/641Jd3zbh0kdPt+eegh75U56KXbvrpopOL+uqst+66g6S/LvvstJOmeu2456777mSqyieeTx+pNYofyOu7WSjWSRC6TP4+IO/QRy997rd3nDnak5fd7zfhNBteoPf2yc053bHrVH5O5xMHfm58C7y+bekP9v5s7Rum9fDlBY/+/LtWxmDc1zNO/UTGPwsVRl8r+drftIcy7hXwYA981v/cFEEJOTCAhzsbAm1XQdEMMEPxuw2TNmi97B3rgibc3mlISJ8Ogkh84SGfC4miJoLNcEUwfJ7jUniUGh7qhjDKIYVO04E7tYAFGjDizqw2NJT4kIMY/N7mYkjEgdjlJB8QSAUaMJZ29SlFIWuiSqjmISCWcYo6tBwPp0LGqq2RgGgc4g4ZmKQ2VseMlglhTT7YNjz674l58yNl+BjIKIYPKODalyAn7UNIwb0RhDoCpFP0KJw4koiS8jNkbkhnx1c9UmYopCMcP1nIlCQyg5akUWbiU7yxpIAAZ+FTnualoUUqUpMJlGRjMNmbUK6NlI4UZUt0BiEhXlKGuJwNL2E2RjFqjnLjm+Mvhfmc/SwTQ6kkEjKBCblqNqiWyYxNI7sZTgOu8Jv7K6dqxok5brZTMsSUHDV75ksVuvOZB3QmxmwZGXbOxTwQQAEX4dOe9zztA3f6wNK2ps5iZuWUVbkmOKFJRTXOM5jTzKi46um+hkLxnthzkj9DqtGOgvRuFE1j9zwqGoky9KTf4WgJL0pOmEoxpdZytGhJZ7rTUYpUpj7tKSRZ+sJsTsmlzLTpIZW6SWOqcnpQjapUQVe9qVr1qli1D1KzytWu6q6qXg2rWMd6qK2S9axotZhZ08rWtjpsrSspYgvk2jwFGK9H52oBCNyFoleeBQR3PVIHAosiECgxml3aE/KYhD/iEfZIgKXlhVRAgbXoL0N+JQsXK9qlOj22r5e9UAcKwjwTZTFekgVtai902s9q062wja1sbQbX2dr2tiCqLW53y9vIgLVtJQmucIdL3OIa97jITa5yl4tcoA6VqfDjp5mM8do7adqTpu8UKigrt1LoKlO6u3Tqa3V6Xe2WErvMGSlK0UvS8rq3gdwFL5jkKyn6Kka9WblfaIG3WunYl4KXUWDi/gsn5+LlPAWRFxLlUhfLmmDBLWjweZYW2UUVhL3rdQxEaUPgw+AXK/p9sAbkYh6xQLjErtyvybzbv8TUcIILNO98PrxUDKNyaiy0IVFFZODzyrimUNFlqTpsGBo3dcc4LIqQD6PbulFXTtu08U1xsmQgETlRPcboe3maSxgfmcWvMXJ0kQyjKmd4y1fLMpB/HBsfNvnN4j1qlNn8Ry9PVMo1PmF8yXzGAOfYv3zOY5zhq0tek3rKzm+7sl+aLObvBlonf97noynDaDVnF81KibRV4DxpRloan3SmMqIbpehi4fSY1jV0TjQd3k7f8tRP/QwSD3uSWb4LtXcuab7QOWYwQ/DJiyJNhU+y4Fk2Fown23U8i+prh8J6vN3FM0s2PF9X+3bQUE41lzPdSaxwutkW3DO4WxpJVifa2tN9tpy1HdTGdFt96G61ugkd7VDD08zAine1553tQm+7Ve/2Maa3i9h6D1zg1O61tAP06faq+uBZwne6F06/hp/54RgXSsCXpW8xWfzGFG/xVTYOsVLP9KXRIrc3yA2T8BhDnDooN2fIZe5nidNL5cGJ+a/HzezhtPHbPxX3zHc+9HOa+8tBL3hl4pNZlhw71y+/dMa7POqT6HPielY6ZV5ZAAloYKEqkWVfFPvFZF0Y53mOugRbTmpga2qVwTvPBJAoEAuMmO5y8SLUp/7ckA/q6vJOOmdNbinCo0U8yw6i21PF7r6jHekvSfxHBa9Sw3Oc5zaKOK8vbrSPT/nxCp8m4B3eeaGD3tGYx4zk17xR06ud9O2ez9CAnvXBd1wxtDdOPHMPX62nXvG/98vqnRx8y+jc2UWfvNEF3MLbJ+b4yn895+vMfBE6v8D1rud7H6+v8c3L8/Ti9HzatS/wQ3t/SdwvsvghL/2Vs3z0ACx+ZaAvlfMEFi6uTaf8Ke01U8IfKbxXer7nGGFRAoGhVxNgLnGhV+8xACTWFxCmKWfXfp9XFWynY/vnadmnGOQxWkvDFhXWAQY1L00DAXfxUslHbltRdd1ieV5Bf4lhf/21Khn4ainYc7VXeelXGAEYe/+WZhvog0LoeBQ4fgJoezV4bTu4aC64FTCYeUtoajcIhfwWbI23fUmIdUXIPusXelvoheSnZb2HhFOYZFkYeOAXZl2IemUIfG3YZ5SXUwYXhqxHh1J3hDp4hvv2hoIWhSeGt4Yp94VsmIZEl4Ny2IRgo4f15Ydu8YRmyIdrooi4h21W6G9DiIWQyH+LRytN1lue+ImL1omgOIqk6G2iWIqomIqTdIqq2IquWBqs+IqyOIvEEYu0eIu4uG65uIu8qFa9+IvA2Cy2GIzEiIq/VYzImIweMozK2Iy3dYzOGI3SyIPMOI3WeFbq0HiN2riN3SKKdJd/F/J084FgAFBaJqIuAMBXjKVi49geV5SHeIU84vgcWZQA7PgcIHBFEdg8i9UjICAA9/gcHQB2A6haZNGPPTKP/tFgjDUA6kg8F6CQyVEWBZCOZRdrUEJ2TiKRzPEBD8mPFzkfHfCAMzhZCImRUCJXdLWOJckcTcckFZYCJriRAZkcMTmT8MiNOrmT3ciTPvmTUpGNQDmURFmQRXmUSGmUSbmUTFmJTfmUUMl4lkiEdghqghiIqDaVmEiIyMeV0ZeVc/iDVCmWW9l6SkmW5YeWYqiWMAeINHeVb1mVsCc2/W5ZiHBpl3I5fXQZhGN5iWnpl2sJhGcJmHXIlndImM/hiG7olSooiQBWhW93hX/Zl5RZlmOYk3fZlZn5lYaZXnWpmXnpfqFZgZd5iIx4eIiYLamJFYoJh4yJg5vZmHEIlqs5LbW5abdZFa3Zh47Zdr3JZJQYmeUSd/vFkXvXmXO5GP8Hb7+pfnx5YMTZRfBiPHsynSnmAQJBkJ6UiVZWRyyof9wpJJ/5FCFGdih2kOsBS/xlYQQRnkoYGbs2YKf5FbtZFOWpP+eZPyk2gz1YmeV2gZnUnFj2nP8UnbfmLtVpkespjv1pmUKzQcsZoO7pGPWpiQLKhHNxdOd2oXjeUaHdyaGUsoIaCoC5SRUeaoOvSYVs9J24OZ8vOJ6ymaKPyG0smogT2hgn+p43uodKVqOF56JOCKOwOZpGuBM2h6Eg2ohCqqIyupir5qOLmKSYsqQzGptDunbDh6JWymMEGpj+6aX+l6WuuaWZkaNaSKTs50RQGqNkihlmioZt2mdHGpfIKUBU6qRoOhsjmqZ1GlNdWpiIaRta0qCTSXBk2KRj6nOIRqhgSk9/ephfyhlmxqiAupeDGamQqnprumI7GqWziZJAaqOauqnbiai8+anQVqItaBl7epyBmpyO/3qpDvqqOEaqgCall4equhiWtGoVrQqephqJukpvqhqUwverPUGpmRqrhxqnp/pQtoozxRoVlfaoVpmnPjGnkzStUFGtslqo4EpD0Uqt3IqBw9pvvIqpRoqsbtSpk7iJyTJnW8quqhmq9QqZUpmus2oT2sqD5bqt8Hotp0F3AkFrwIpp1Wd14+qb7vqY5+qUmeE867lEazRB/aqjwWqhDyucn6E8SjRLEMaQEtieGpUvsNqoKNuW1toYfmVs7aGgN+deyiaafUqaeGial4FE79hgedVKJ8aOAehlAPqhDcuwhkib9uptkTcTJGe0ziqsRwuquDoqPXqx91q0wBmwQgt5rTX7pPQKsFM7ZN5ay4rKWrULyzJJa5tjK6/YOhRDi7ZhK6pm2axtS6df0bTf97QaG7WpmrYtyhhvK6EZS7R8u6v/WnI1d7b5FrdXW7jE6rcRpRp4y6mDq6WlibSMq7S8wXZle7Iq+60pu6x66maHK2n4yols27WvEbg226s5d6eJqrq9Nrmc6bq88aY8qreE20xfC6d1u06w+6y6a7mRR7ueWrn9FLxQO7wY67WKm6vIS6HKu7fMe6bZarWNW704Or27+7ugabbPi7iZexW4e7zam7tBhr1wi7XOCbqVuq/wKxWsu6HsO6D/7iu67xuuWGG85lO6SVG+7zq+f6uc6otNAqyb3Eu8tsun7sa/TQK5JprAzeu9tcuq/dq5drqyehm/oZu434nBfnq/XLvAYKioSgLCr6vBNEvCg5ghDoyVN4u59YukM1ws81vBhoqZLBt3DiifB9yuQkVyCeu7MSy1SNMXErsSxrm4NRyi13NK4Zu9l2vEw1kCSZQSebVX6wGBIxZh7+gnE0jBbNq2M9u9Rdy3k3EeJKaetVZQW+xKL/uRNNjEP9psN4yaa4sZ8TFremU8IpieZ/Gz/Om/JKpOL0y1eayV+ou/jKx5XzPE6HvGhgvBq/rDlXwTYjrBkvy4lmyslOzJE/gSocs7xWhMx3jcyeRKE6Icu4LVSbey28JifKW8C8k4zKw6/MowzMK53AKZLMuW6sq6bLfqSnqr/L2tfMvBjJe4THO9rMzHjLOmDL3nu4jNvMs5DM3RS8TJDCHFXKS/jMzDvMGLrHvd3LrfjM3THMDRPHIGg8K3K8HWu821vLlN5M5cqMLmzMH5K6jnZ88Mh8/erM+N7DKA588VB9AMHM4rvLr/Z9Dhh9AlLM9jzNC0zMTZzBgA7LAXbb7LZ32oDBUZ7bSxzKQEfX7N99FPEdJZi9Jg+xnVPMcbfV/wrM0Knc/wadKCm87P/zfTkSzRvtzAOM2c6xykEA3Ly+zMBBzU/fvJ/cLTHH3UxuxiSs1hTA3STq3OMa3R5lfRVM3STaHSP1TV5ooYLy3UWY19Iuy5Ay3OIjrV8TfUp3LVWj3SVfqgXE2/Z+1hcu0TXMc8/1iTleTVposf31TWiyPY/7vXPREWIzCTKtAAfDEW6GgneIIADGAADqBECIWCeR3W0Nq7eUvXbqrYPMEWCjVXGTA8sqSegsyeAwHXUiy/Jqu2iI0UYL0T5rIAImCC5qGeYtcWj22AIWnROi3SVFHALifaMkLauN0XWsxfBGt3qR086mKOpVrcK03Ydy2+sM2azE0Vm23A3U3b4yw9wI6LroS8vp3tr2KdMN8thetNw/EN33MLzgI9wjUd0OOcHLct39jt2eUdubKJrK/7zdb7fOCJ+d5OXNvq/d/sfbrxKpkdrNb4fd/8reB1HOBA7OD+TcqTzOA2k94h3t5fjeGnrOGXPN8LvrH5KuLSSuKDreJKWtTWXOALbeEGnuA0Lsw4fuM2btMzZuLSrNzCS+SjvMnoDeNEA+IvzuRE0d/0beTUK+Vm/MwyLOMnjuVDDtXhltY5XuE/rt8TnsFe7uNjbuYIDuZBvuNI3eNAnuYUfuFsHtVuLuZw/uVywl7mb77WaM7ne+6Zcz7Pd97naj7oKazndu7niV7oin7PiJ7QdQ7pYS7pa/7oEZ3flG7oi57nwIzplx7pnz7p/2zpRu3TJE3lCnzOV87hUc7lE23qZSrkLxgCtF7rtn7ruJ7rur7rvN7rvv7rwB7swj7sxF7sxn7syJ7syr7szN7szv7s0B7t0t7ssh6V1m5bW3vt2i6N2b7t3p6M3f7t4g6M4T7u5p6L5X7u6i6LzNXu7v7u8B7v8j7v9F7v9n7vJREQADs=" ALT="MyPic">

 

[bofonomo]

Hi Thanks a lot,

I will give both these a try. I ended up simply taking a screen shot and rotating 90 degrees, then having to rotate the axis lables to. A little bit of a fudge as a method.

 

[bofonomo]

Sorry when you mean camera, do you mean the Print Screen button on the keyboard?

 

[pgc01]

Sorry when you mean camera, do you mean the Print Screen button on the keyboard?

No, the excel camera tool.

Right click on the Quick Access Toolbar, choose "Customize Quick Access Toolbar". In the "Choose Commands From" dropdown choose "All Commands".

Look for Camera and add it.

 

[Steve=True]

I have created a tutorial showing you how I created this using the Camera Tool in case you need more help:

http://www.exceldashboardtemplates.com/?p=778

Good luck!

Steve=true