Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
setting axis from columns without using row number for line chart
Hi,
Could you please provide the steps involved in creating a line chart with column B as the y-axis, and column C, the x-axis? My attempts always lead to the row number as the x-axis. I am using the trial version of Excel. Regards, William Johnston |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
setting axis from columns without using row number for line chart
1. Without any cells selected, click the "Chart Wizard" button, or use the
menus by going to Insert -- Chart. 2. Choose the chart type and sub-type of interest (Line Chart, in your case), click "Next." 3. Click the "Series" tab, click the "Add" button. For the "Values,", choose your y-axis values (Column B). 4. For the "Category (X) axis labels," choose your x-axis values (Column C), click "Next." 5. Fill in your chart options (title, axis titles, etc), click next... etc, until you finish going through the chart setup (at any time, you should be able to hit "Finish" which will just give you blank titles and the options will just be set up as default/auto values). Hope this helps, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting axis parameters for a chart in the worksheet | Charts and Charting in Excel | |||
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 | |||
How do I set Line chart y Axis variable X axis value? | Charts and Charting in Excel |