Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 26
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting axis parameters for a chart in the worksheet Steve S Charts and Charting in Excel 1 July 14th 08 08:30 AM
How to manually switch data from x axis to y axis in line chart? scs.hq1 Charts and Charting in Excel 1 January 25th 08 02:56 AM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
How do I set Line chart y Axis variable X axis value? John T Charts and Charting in Excel 1 April 18th 05 04:36 AM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"