LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fairly easy (i thought) copy and paste cells, increment by 17 accross swatsp0p Excel Discussion (Misc queries) 1 May 25th 05 07:55 PM
fairly easy (i thought) copy and paste cells, increment by 17 accross bleugh Excel Discussion (Misc queries) 0 May 25th 05 06:27 PM
another thought on COUNTIF 2 VARIABLES ?? Alan Excel Worksheet Functions 1 November 27th 04 03:25 AM
On second thought ... Jerry Kinder New Users to Excel 0 November 26th 04 02:38 AM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"