This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How can I rotate a line chart (or x-y axis chart) so the lines move top-bottom instead of left-right
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
google is your friend. I found lots of tips on the topic
This tip gives 3 suggestions:
http://www.exceldashboardtemplates.com/3-ways-to-create-vertical-lines-in-an-excel-line-chart/
That tip gives three suggestions for adding a vertical line to an Excel Chart - that's not what I want to do
I want to rotate a line chart (or x-y chart) so that the bottom labels become the other axis - see example here. I need it data-driven and with text correct like when you change a vertical column to a horizontal bar chart
I don't think I've ever seen that sort of a chart. What is the purpose of this type of chart?
See attached. If it's the same way round as a line chart it can get confusing - it has no time axis - is this clearer now?
This last example is clear, but I simply have not seen excel used this way. What is the general purpose of this type of chart (just curious).
OK, I found another example:
Bar-Line Combination Chart
http://peltiertech.com/Excel/Charts/BarLineCombo.html
Use the "line" portion of the example. I think it gives you what you are looking for.
If not search that site as well as these others. They have lots of content, and probably have something that does what you want