Thanks. I thought I licked this like 15 years ago on my Mac... But still
having same problems.

I tried what you suggested. What is fouling me up is that when I do THAT,
Excel treats each data point as if it is the same "distance" on the X-axis as
everything else.

Let me try to explain:

Let's say my graph is six inches long.(!) I have six data points, which a
10, 20, 30, 40, 50, 60

So, on the graph, you would expect each point on the X-axis to be one inch
apart.

But let's say I have 10, 20, 30, 50, 55, 60.

You would still expect the graph to be six inches long, and you would expect
10 to be one inch from 20, 20 should be one inch from 30, 30 should be TWO
INCHES from 50... 55 should be HALF AN INCH from 50, and HALF an inch from 60.

But what's happening with my graph is it is still treating those six data
points as "equal". So each point is one inch apart. Which gives me a wacky
slope, and certainly doesn't show what I want!!!

In high school, long before we had personal computers, I could have drawn
this on graph paper in less than half the time it has taken me to type this
post!

Argh!

"rmellison" wrote:

I am somewhat of a novice, but have been battling with line charts myself in
recent weeks so this may be of help.

Select your two sets of y-values only and run the chart wizard as per usual.
Choose line chart. You should get two series with categories 1 to 5 along the
bottom, as you do at the moment. Your y-axis should look ok.

Right click the chart, choose source data and edit the category(x-axis)
labels box at the bottom of the window. Select a range of cells to represent
your x-values, 100,90,80,70,60 etc. You may also wish to Format Axis | Scale
and deselect 'Value (Y) axis crosses between categories'.

HTH

"RJB" wrote:

I am trying to build a chart that regresses two sets of gross revenue
numbers, based on anticipated price sensitivity.

In other words:

Right now, I move 100 pieces a month. Sales price is $75 each. So, gross rev
is $7500.

I want to show what will happen if I raise my price to $100, or $125,
knowing that there will be falloff.

I want my X axis to be units sold - left to right - 100, 90, 80, 70, 60

I want my Y axis to be total revenue, at each price point.

So, I want two lines:

Line 1
(100, $10,000), (90, $9000), (80, $8000), (70, $7000) and (60, $6000)

Line 2
(100, $12,500), (90, 11,250), (80, $10,000), (70, $8,750), and (60, $7,500)


No matter how I set my datasheets, and run the wizards, I get an X Axis of
1, 2, 3, 4, 5
And my Y axis is all over the place - the first line has the right values,
and the second line is a weird combo.

This is SO basic, but my brain is frozen, and it's Friday night and I want
to do this and go home!


Thanks