ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I change the orientation of a chart in Excel? (https://www.excelbanter.com/charts-charting-excel/68136-how-do-i-change-orientation-chart-excel.html)

Melissa

How do I change the orientation of a chart in Excel?
 
I have a scatter plot that needs to be displayed vertically instead of
horizontally - i.e. x-axis on the left side and y-axis across the top. how
do I go about doing that???
Thanks!
Melissa

Bernard Liengme

How do I change the orientation of a chart in Excel?
 
In an XY chart the x-axis is always the horizontal one.
But you get to chose which are the x-values.
Put one set of data in column A, and another in B; the ones in A will be the
x-values when you make a chart.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Melissa" wrote in message
...
I have a scatter plot that needs to be displayed vertically instead of
horizontally - i.e. x-axis on the left side and y-axis across the top.
how
do I go about doing that???
Thanks!
Melissa





All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com