Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
another thought on COUNTIF 2 VARIABLES ?? | Excel Worksheet Functions | |||
On second thought ... | New Users to Excel |