View Single Post
  #1   Report Post  
RJB
 
Posts: n/a
Default I THOUGHT I knew what I was doing

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