How do I get a column to appear along the horizontal axis of chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aristaeus - 13 Mar 2007 17:56 GMT

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 to this Message

Andrew - 20 Mar 2007 12:28 GMT

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.

> 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
[quoted text clipped - 4 lines]
>
> Any suggestions most appreciated.

Reply to this Message