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 |
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 |
All times are GMT +1. The time now is 11:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com