ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Rotating a line chart? (https://www.excelbanter.com/charts-charting-excel/107642-rotating-line-chart.html)

Roe

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.


Tushar Mehta

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.



Jon Peltier

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