setting axis from columns without using row number for line chart

  • Thread starter Thread starter williamj
  • Start date Start date
W

williamj

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining X axis in Charts 2
create chart with column axis 10
Exel - add vertical line to two axis graph 0
Excel Excel Dynamic Charting in rows 0
How do I eliminate empty cells from plotting on chart 1
Chart distorts secondary axis when the x-axis is logarithmic 5
swapping axis' 5
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4

Back
Top