ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   y-axis versus x-axis charts (https://www.excelbanter.com/charts-charting-excel/159858-y-axis-versus-x-axis-charts.html)

bigesimm

y-axis versus x-axis charts
 
What I'm trying to do is have the numerical data in the y-axis charted versus
the data in the x-axis and there seems to be no way to do this because all of
the charts given just plots the data for both the x-axis and y-axis but not
against each other if you know what I mean and can help that would be
appreciated, thanks.

Jon Peltier

y-axis versus x-axis charts
 
Put the X values in a column. Put the Y values in the next column to the
right. Put a label in the cell above the first Y value. Keep the cell above
the first X value blank. Select this data, including the top row with the
blank and the Y label, and start the chart wizard. The blank cell helps the
chart wizard parse the data range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"bigesimm" wrote in message
...
What I'm trying to do is have the numerical data in the y-axis charted
versus
the data in the x-axis and there seems to be no way to do this because all
of
the charts given just plots the data for both the x-axis and y-axis but
not
against each other if you know what I mean and can help that would be
appreciated, thanks.





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

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