![]() |
Rotating a line chart?
Is it possible to rotate a line chart so it looks like a vertical chart
rather than a horizontal chart? And if so, once it is rotated, can one still interact with the chart and it's data? Thank you. |
Rotating a line chart?
Visit Excel Tips and Cases
http://www.tushar-mehta.com/excel/tips/index.html and scroll down to 'Invert and rotate charts' The direct link http://www.tushar-mehta.com/excel/ti...0invert%20and% 20rotate.pdf is almost certain to change in the near future. The above applies to a XY Scatter chart. Hopefully, you can use that instead of a line chart. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... Is it possible to rotate a line chart so it looks like a vertical chart rather than a horizontal chart? And if so, once it is rotated, can one still interact with the chart and it's data? Thank you. |
Rotating a line chart?
You can make it as an XY chart. You might have to fake the vertical axis so
it has the category labels on it: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Roe" wrote in message oups.com... Is it possible to rotate a line chart so it looks like a vertical chart rather than a horizontal chart? And if so, once it is rotated, can one still interact with the chart and it's data? Thank you. |
All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com