Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default How do I get a column to appear along the horizontal axis of chart

I have two adjacent numerical columns; when I select them to create a chart
Excel chooses to plot both columns vertically side by side. Instead of that I
want the left column to appear along the bottom of the chart and the right
column to be vertical.

This is probably very simple but it is doing my head in.

Any suggestions most appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 358
Default How do I get a column to appear along the horizontal axis of chart


Hi,

Sounds like it's a Scatter graph you want to produce - just select XY
(scatter) as your chart type and it should get the result you want. You can
then add a trend line to get linear representaion of your data.
Hope this works/helps.

Andrew.

"aristaeus" wrote:

I have two adjacent numerical columns; when I select them to create a chart
Excel chooses to plot both columns vertically side by side. Instead of that I
want the left column to appear along the bottom of the chart and the right
column to be vertical.

This is probably very simple but it is doing my head in.

Any suggestions most appreciated.

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
Horizontal Time (X-axis) Bob Charts and Charting in Excel 2 July 21st 06 01:39 PM
Column chart with both value x and y-axis chris46521 Charts and Charting in Excel 4 July 3rd 06 03:34 PM
how do set up a chart with vertical and horizontal column heading claireann100 New Users to Excel 0 June 27th 06 01:51 AM
how to set up a chart with vertical and horizontal column heading claireann100 Charts and Charting in Excel 1 June 26th 06 09:46 AM
2 Axis Column Chart dguilbault Charts and Charting in Excel 4 April 5th 06 12:23 PM


All times are GMT +1. The time now is 02:01 PM.

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"