Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Charts on 2 axis' | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
charts....x and y axis | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |