Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart using one column as x axis, another column as y axis?
I have data in one column that I want to plot as x axis values and another
column that I want to plot on y axis values. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart using one column as x axis, another column as y axis?
Do you want a line chart, which treats X values as non-numeric category
labels, or an XY chart, which treats X values as continuously variable numerical values? You can format the data in either chart type the same (lines or not, markers or not): the difference is in this treatment of the X values. The best way to do this is to put your X and Y values in adjacent columns, X to the left. Put a label above the Y values, but keep the cell above the X values completely empty. Select the range of data and start the chart wizard (Excel l2003 and earlier) or use Insert Tab Chart ... to insert the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "wmaker51" wrote in message ... I have data in one column that I want to plot as x axis values and another column that I want to plot on y axis values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
6 items line-column chart on 2 axis | Charts and Charting in Excel | |||
How do I do a combination STACKED column and line chart on 2 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 | |||
How do I create a Line-Column on 2 Axis chart that allows more... | Charts and Charting in Excel |