Price analysis and Margins

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Hi,

Im trying to create a line chart or whichever chart will
illustrate the following...
I am doing a pricing chart versus units sold. So
basically as price falls, units may rise.
I created a secondary axis for price and primary axis for
sales units.
This works fine...NOW, I would like to put in "Margin
growth" to see if although price goes down and sales go
up, how does it effect the margin%? I need to show this
in ONE graph. Problem is, that Margin % is on the primary
axis and since I have units on there, the margin % does
not show since it is such a small numeric.

Please help? Am I using the correct type of graph? Should
I be using another graph to illustrate this?

Thanks in advance!!
 
Maxwell -

I think you want to change this a little. Put units in the first
column, price in the column next to it, and margin in the third column.
Select this data range and create an XY Scatter chart. Excel will use
units as the X value and the other values as Y values. Double click on
the margin series, and on the Axis tab, select Secondary Axis. Now
Margin is plotted on the right axis, and price along the left.

Alternatively, if you want to treat price as the independent variable,
put it in the first column and units in the second. Repeat the chart
creation process. Now price will lie along X, units up the left Y axis,
and margin up the right Y axis.

- Jon
 
I tried this and it looks a bit messy. I was hoping to
see a clena 3 line chart that could illustrate this. Is
there another way?
 
Tushar -

Seems from his description and follow up to my suggestion that he's
essentially got a line plot, by observation number.

- Jon
 
Back
Top