 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / December 2003Price analysis and Margins
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 ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > Hi, > [quoted text clipped - 15 lines] > > Thanks in advance!! 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? >-----Original Message----- >Maxwell - [quoted text clipped - 38 lines] > >. I'd thought that using one parameter as X values would give a clearer idea of the relationship, from low values of one variable to high values, than just lines jumping up and down together. Anyway, Excel doesn't offer a tertiary axis, but on my web site I show how you can fake it: http://www.geocities.com/jonpeltier/Excel/Charts/TertiaryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > I tried this and it looks a bit messy. I was hoping to > see a clena 3 line chart that could illustrate this. Is [quoted text clipped - 83 lines] >> >>. What do you have on the x-axis?  SignatureRegards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions > Hi, > [quoted text clipped - 15 lines] > > Thanks in advance!! Tushar - Seems from his description and follow up to my suggestion that he's essentially got a line plot, by observation number. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > What do you have on the x-axis? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.