Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Horizontal Time (X-axis) | Charts and Charting in Excel | |||
Column chart with both value x and y-axis | Charts and Charting in Excel | |||
how do set up a chart with vertical and horizontal column heading | New Users to Excel | |||
how to set up a chart with vertical and horizontal column heading | Charts and Charting in Excel | |||
2 Axis Column Chart | Charts and Charting in Excel |