ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Change Value axis to category axis (https://www.excelbanter.com/charts-charting-excel/229402-change-value-axis-category-axis.html)

Ronnie

Change Value axis to category axis
 
Is there a way to change places of the category (x) axis and the value (y)
axis? If so, how? I am using Excel 2003.
--
Ronnie

Jon Peltier

Change Value axis to category axis
 
You can only make this switch if you change a column chart to a bar chart.

But if you want a line chart that's rotated, you can fake it:

http://peltiertech.com/Excel/Charts/DotPlot.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Ronnie" wrote in message
...
Is there a way to change places of the category (x) axis and the value (y)
axis? If so, how? I am using Excel 2003.
--
Ronnie





All times are GMT +1. The time now is 07:21 AM.

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