Swapping X and Y Axis - line Chart
Hi
I have been asked if it is possible to swap the x and y axis over on a line chart i can find infor for doing this on a scatter but not on a line chart. i have tried reformatting the data but this didn't work i want the variable data values to be plotted on the horizontal axis and the static values to be plotted on the vertical axis - i know i can do this via a bar chart but this chart need to be a line chart is this possible? Ian |
Swapping X and Y Axis - line Chart
http://www.peltiertech.com/Excel/Cha...egoryAxis.html
wrote in message ... Hi I have been asked if it is possible to swap the x and y axis over on a line chart i can find infor for doing this on a scatter but not on a line chart. i have tried reformatting the data but this didn't work i want the variable data values to be plotted on the horizontal axis and the static values to be plotted on the vertical axis - i know i can do this via a bar chart but this chart need to be a line chart is this possible? Ian |
Swapping X and Y Axis - line Chart
This one's better:
http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mike Middleton" wrote in message ... http://www.peltiertech.com/Excel/Cha...egoryAxis.html wrote in message ... Hi I have been asked if it is possible to swap the x and y axis over on a line chart i can find infor for doing this on a scatter but not on a line chart. i have tried reformatting the data but this didn't work i want the variable data values to be plotted on the horizontal axis and the static values to be plotted on the vertical axis - i know i can do this via a bar chart but this chart need to be a line chart is this possible? Ian |
All times are GMT +1. The time now is 05:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com