Thanks. Love to try it. But I got an error message - "Invalid attachment
specified"

"Bryan Hessey" wrote:


do you mean as per the attached? I didn't add the original $75 row, but
that should be easy enough as another series.


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


+-------------------------------------------------------------------+
|Filename: BookChart.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3801 |
+-------------------------------------------------------------------+

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=466415