Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Axis Data Location
I want the data in column 1 to be the Y axis scale and the data in columns 2
& 3 to show as a trend line in the chart. I have played with this 10 ways to Sunday and can't find how to do this. How do I identify the Row 1 to contain column headings. When I import it asks me but I typed these in and it shouldn't be this well hidden. Thanks in advance. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Axis Data Location
Try deleting the title in the first column
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Michael E W" wrote in message ... I want the data in column 1 to be the Y axis scale and the data in columns 2 & 3 to show as a trend line in the chart. I have played with this 10 ways to Sunday and can't find how to do this. How do I identify the Row 1 to contain column headings. When I import it asks me but I typed these in and it shouldn't be this well hidden. Thanks in advance. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Axis Data Location
Thanks
"Bernard Liengme" wrote: Try deleting the title in the first column best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Michael E W" wrote in message ... I want the data in column 1 to be the Y axis scale and the data in columns 2 & 3 to show as a trend line in the chart. I have played with this 10 ways to Sunday and can't find how to do this. How do I identify the Row 1 to contain column headings. When I import it asks me but I typed these in and it shouldn't be this well hidden. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock shape location to axis values? | Charts and Charting in Excel | |||
prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
multiple x axis data | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel |