Thread
:
Create simple line graph in Excel!!!!!
View Single Post
#
5
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.office.misc,microsoft.public.powerpoint
[email protected]
external usenet poster
Posts: 4
Create simple line graph in Excel!!!!!
Ok, I got it. I found a spreadsheet on the web, and
checked it out.
The secret is, within the Source Data, there is:
- a single series
- both the X and Y values are assigned to the same series.
Not two series as I was attempting.
Too bad that Microsoft doesn't make this obvious anywhere.
Graphs line these are very common.
Thanks for responding.
wrote:
Ok, I've struggled with this far too long now.
And abandoned the task a number of times over the past year.
So, I'm going to ask you now.
I have two columns of data:
u a
v b
w c
x d
y e
z f
etc.
Where u to z, and a to f represent numbers.
I want to see a simple graph with one column representing the
X axis, and the other column, representing the Y axis.
And a line, showing the relationship between the two.
It should be simple right? Unfortunately, it hasn't.
I've tried to create a scatter graph with lines.
And a line graph.
But excel just doesn't want to cooperate.
It wants to make each column a separate line.
Not the axis.
What is the secret please? I'm using Excel 97.
Thanks a lot!
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]