Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Add drop lines at plot crossovers, swapping X and Y axis | Excel Discussion (Misc queries) | |||
How do I set Line chart y Axis variable X axis value? | Charts and Charting in Excel |